Slider

How to Freeze Specific Cells in Microsoft Excel

Date:2019-7-17 Author:Cordelia

A large table with tons of data usually can't be fully displayed in a single page. You must scroll down or scroll to the right for a more complete viewing. In order to correspond these data with the title or other key content intuitively, you can freeze some specified cells in the table. In this way, even when you scroll down the page, the selected content will always show at the top of the page.

How to Freeze Top Row and First Column in Excel

1. Switch to View tab in Excel, find the feature called Freeze Panes in the Window section.

This image has an empty alt attribute; its file name is myofficetricks.com_2019-09-29_09-26-07.png

2. Click it, there are two common used options: Freeze Top Row and Freeze First Column. As their name suggest, you can simply freeze the first row or the first column in the table by selecting them.

Click Freeze Panes in View tab

How to Freeze Specified Cells in Excel

If you want to freeze a specified area of cells, you'd better make use of the feature Freeze Panes.

Freeze Panes allows you to freeze a specified range of cells, but not in a direct way. When you click a cell, the intersection of cells above it and cells on the left of it will be specified as the panes to freeze. For example, when I click D2 in the table and select Freeze Panes, the cells from A1 to C1 will be frozen. You can see the black borders around them which delimits the scope of cells to be frozen.

Freeze Specified Cells

Now when I scroll down the page, the cells above the horizontal border line will always stay at the top of the sheet; When I scroll to the right, the cells on the left of the vertical border line will always stay at the leftmost of the sheet. And no matter I scroll down or scroll to the right of the page, cell A1, B1 and C1 will always stay at the same place.

The result of Freeze Panes

How to Unfreeze Panes in Excel

If you don't want to freeze these cells anymore, just click Freeze Panes again and choose Unfreeze Panes in the drop-down list.

Unfreeze Panes

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *