zen-box

 

Our Business is Making Technology WORK for Your Business

 

Jul
02
2012

Freeze Panes in Excel 2010

When dealing with large amounts of data in an Excel workbook, you often need to use the Freeze Panes item on the ribbon. This option allows you to keep a certain area visible as you scroll to other parts of your worksheet. You can freeze rows, columns or both rows and columns.

Freeze Top Row (only)

For example if you have a worksheet with column titles across the top and several rows of data, as you scroll to the bottom of the data you would not be able to see the column titles unless you freeze the top row. You would do this by simply going to the View tab and selecting Freeze Panes\Freeze Top Row. I have highlighted the line freezing the row in red in my example:

Excel Freeze Panes - TopRow 

 

Freeze Left Column A (only)

If you do not want to freeze the top row, but want to freeze the first column of your worksheet, go to View\Freeze Panes\Freeze First Column. By freezing column A, as you scroll to the right you will be able to see the data in column A no matter how far to the right you scroll. I have highlighted the line freezing the column in red in my example:

Excel Freeze Panes - LeftColumn

 

Freeze Both Top Row and Left Column A

If you want to freeze both the top row and column A, select cell B2 and go to View\Freeze Panes\Freeze Panes. This will freeze Row 1 and Column A so that as you scroll through your worksheet, you will always be able to see the titles across the top and the data in column A. I have highlighted the line freezing the row and column in red in my example:

 Excel Freeze Panes - Multiple

 

Freeze More Than One Column and/or Row 

If you want to freeze more than one column or row at a time to lock them in place as you scroll through your worksheet, you can do this by selecting the cell that is directly below the rows you want to freeze and/or directly to the right of the columns you want to freeze. After you have made this selection, go to View\Freeze Panes\Freeze Panes. I have highlighted the line freezing the row and columns in red in my example. In this case, I started by clicking cell C2 before selecting the Freeze Panes option:

 Excel Freeze Panes - FreezeBothPlus

 

Unfreeze Panes

To unfreeze panes, simply go to View\Freeze Panes\Unfreeze Panes:

Excel Freeze Panes - Unfreeze

 

If you would like additional instruction or information on the Freeze Pane item in Excel, I have included a short training video below. If you need assistance on any other Microsoft Office ribbon item please feel free to Contact Us - and don't forget to "Like" us on Facebook! Thanks and I hope this has been helpful. Arlene

 

Arlene Dickerson

Co-Owner / Finance & Training Director

Technical Resource Solutions, LLC

This email address is being protected from spambots. You need JavaScript enabled to view it.

 

Arlene Dickerson-Lavelle

Arlene Dickerson-Lavelle

Arlene is Co-owner / Director. She is an Excel power user and is your contact for Website Design and Training Services.

Related items (by tag)

Leave a comment

Make sure you enter the (*) required information where indicated. Basic HTML code is allowed.