One thing that you may have learned to do (in older Excel versions) is keep data relevant by maintaining the visibility of row-header (left column) and column-header (top-row) title information by using the Excel option freeze panes from the window menu.
If you have a huge data set, you might want to lock the header cells containing the credentials of the data table. Usually, you will have the credentials at the top row of your data set. Also, it is very likely that you will have to include credentials of your data set across the first few columns.
How To Freeze Cells In Excel Microsoft Excel includes a very handy tool that keeps certain rows or columns visible as you scroll up-down or left-right. Now let’s see two hypothetical examples and learn the use of this life-saving feature.
Lock Multiple Rows Let’s break down the instructions. In the below screenshot, you can see I have merged the 1st, 2nd, and 3rd, 4th rows together. So, now I want to freeze the first 4 rows. In order to do so, I have to select the 5th row.
Hover your mouse over the rightmost corner of the spreadsheet and click on row 5. After you have clicked on the 5th row, it will be highlighted in a dim blue color. Now, Head over to ViewFreeze panes and pick the first option- Freeze Panes. You are all good to go. Now use the mouse to scroll down and you will see the first 4 rows have been locked.
![How Do You Freeze A Row In Excel 2008 For Mac? How Do You Freeze A Row In Excel 2008 For Mac?](/uploads/1/2/5/4/125498686/408913936.jpg)
Freeze Multiple Columns In the screenshot below, you can see the first two columns are highlighted in green. Now, let’s freeze these two columns. In order to freeze the 1st and 2nd columns, I need to select the 3rd column and navigate to ViewFreeze Panes. Hover your mouse over the 3rd column and right click on it.
Now head over to ViewFreeze Panes. From the drop-down select Freeze Panes. Now use your mouse to scroll horizontally across the spreadsheet. Want to learn more Microsoft Excel tricks? Here is a quick blog that will teach you.
Click Freeze Top Row. Scroll down to the rest of the worksheet. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen. Note: to keep the first column visible while scrolling through the right of the worksheet, click Freeze First Column.
Unfreeze Panes To unlock all rows and columns, execute the following steps. On the View tab, in the Window group, click Freeze Panes.
Click Unfreeze Panes. Freeze Panes To freeze panes, execute the following steps. Select row 3. On the View tab, in the Window group, click Freeze Panes. On the View tab, in the Window group, click Freeze Panes, Freeze Panes.
Scroll down to the rest of the worksheet. All rows above row 3 are frozen.
Note: to keep columns visible while scrolling to the right of the worksheet, select a column and click Freeze panes. Select cell C3 ( first). On the View tab, in the Window group, click Freeze Panes, Freeze Panes. The region above row 3 and to the left of column C is frozen.