Freeze Panes in Spreadsheets

Freezing the panes in Excel allows you to enter multiple columns and rows of data and still be able to view your column and row headings as you scroll down or over.

Freeze Panes in Microsoft Excel 2007 and 2010:

  1. Open your document.
  2. Select the "View" tab > Select "Freeze Panes" from the "Windows" group.
  3. Select either "Freeze Top Row" or "Freeze First Column." Choose "Unfreeze Panes" to unfreeze your panes.

Keywords: freeze cells, cells in place, office 2010

Help Page Feedback

Did this content help you? *

What is your opinion about the content? *

Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty