Freeze panes to lock rows and columns

To keep a row or a column visible while scrolling down to another area of the worksheet, freeze panes feature in Excel is used. Following are necessary steps to get the results:

Freeze top row

1.  In the View tab, Click Freeze Panes in the Windows section.

Freezing panes step 1

2. Select Freeze Top Row option.

Freezing panes step 2

3. A dark grey line under the first row will appear which means that top row has been frozen.

Freezing panes step 3

You can see row number 2, 3 and 4 have been moved up while scrolling down and row number 1 with dark grey underline has been frozen.

Freeze the first column

To freeze the first column same steps will be done except Freeze First Column option will be selected in above-mentioned step 2.

Unfreeze Panes

To unfreeze the frozen row or column, follow these steps:

1.  In View tab, click Freeze Panes.

Freezing panes step 1

2. Select the Unfreeze Panes option.

Freeze panes of your own choice

To freeze a row or a column of your own choice, following steps will be performed:

1.  Select row 3.

2.  In the View tab, Click Freeze Panes in the Windows section.

Freezing panes step 1

3. Select Freeze Panes option.

4. As you can see first 2 rows have been frozen.

Note: for a column to freeze, same steps will be followed except column will be selected rather than the row selected before in step 1.

Shortkeys for freezing panes

To freeze a first row, press one by one Alt, W, F, and R.

For a first column, press one by one Alt, W, F, and C.

To freeze panes of your own choice, press one by one Alt, W, F, and F. (Note: you will need to select a column or a row to freeze before pressing short keys)

For unfreeze, press one by one Alt, W, F, and F.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved