In Easy Steps Articles

March 16, 2022

How to freeze panes/rows/columns in Excel

When you navigate a worksheet, column headings and row labels will move off screen, making it more difficult to identify the data elements. To keep these visible, start by clicking on the worksheet:

1) Click the cell below the headings and to the right of the labels (e.g. with one row and one column, choose cell B2).

2) Select the View tab and click the Freeze Panes command, from the Window group.

3) Choose an option from the list; for example, Freeze Top Row.

The first entry in Freeze Panes now changes to the undo option, Unfreeze Panes

Find more tips like this in Excel 2019 in easy steps.

£11.99

192 pages
By: Michael Price
ISBN: 9781840788211

Sign up to our

Newsletter

Our newsletters inform you of new and forthcoming titles, handy tips, and other updates and special offers. You can opt out anytime.

"*" indicates required fields

By In Easy Steps Team

Share