SEARCH

How-To Geek

How to Freeze and Unfreeze Rows and Columns in Excel 2013

00_lead_image_rows_and_columns_frozen

If you are working on a large spreadsheet where all the rows and columns of data don’t fit on the screen, it would be helpful to be able to keep the heading rows and columns stationary so you can scroll through the data.

You can freeze rows and columns in your spreadsheet. To do so, select the cell above which and to the left of which you want to freeze the columns and rows.

01_selecting_cell

Click the View tab.

02_clicking_view_tab

Click Freeze Panes in the Window section of the View tab and select Freeze Panes from the drop-down menu.

You can now scroll through the data while the heading rows and columns stay still, as pictured in the first image in this article.

NOTE: Frozen rows and/or columns are indicated by a thin black border.

03_selecting_freeze_panes

To allow the frozen rows and columns to move again, click Freeze Panes in the Window section of the View tab and select Unfreeze Panes.

04_selecting_unfreeze_panes

You can also just freeze rows or columns. For example, to freeze the header row for a long table, select a cell below the row(s) you want to freeze.

05_selecting_cell_for_first_row_freeze

Click Freeze Panes in the Window section of the View tab and select Freeze Top Row.

06_selecting_freeze_top_row

Now the heading row(s) will stay in place as you scroll through your data.

07_top_row_frozen

This feature is very handy for viewing long, complicated spreadsheets.

Lori Kaufman is a freelance technical writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.

  • Published 06/27/13

Enter Your Email Here to Get Access for Free:

Go check your email!