Notice the grey lines that I pointed out with the green arrows. For example, if we wanted to freeze all the rows from 3 and up in the below screenshot, then we would highlight row 4 before executing the Freeze Panes Hotkeys. To freeze a specific row (or specific rows) we need to select the entire row below it. ğreeze the column(s) and row(s) above and to the left of my selection Freeze the rows above my selection.ğreeze the column(s) to the left of my selection.You have 3 different options in how you execute the freeze panes shortcut. While the freeze panes hotkeys are easy to execute, what’s more important here is how you execute the shortcut. The ALT + W + F + F hotkey will freeze panes for you in Excel. To freeze the top row and first column in Excel you simply need to know the following shortcut hotkey: ALT + W + F + F Let’s get started! Part 1: Technical Overview – Freeze panes on the top row and first column of your data Today I’m going to show you how to freeze the top row and first column of your data in Excel! The first part of this tutorial will be the technical walk-through that outlines steps needed to freeze panes for the first row and first column, while the second part of this tutorial will be a conceptual overview of why the freeze panes functionality is helpful when creating reports in Excel.

Freeze first two rows in excel