Windows  |  Free Downloads

 

 

 

Freeze Panes in Microsoft Excel

While scrolling, if you want to freeze rows so they stay at the top and/or columns so they stay at the left, all you need to do is freeze panes.

To freeze panes, hit WindowŕFreeze Panes.

The rule of thumb is this:

  • Any rows above your cursor will freeze when you freeze panes
  • Any columns to the left of your cursor will freeze when you freeze panes

To freeze just the first row, click on A2 first.

To freeze just the first column, click on B1 first.

To freeze both the first row and the first column, click on B2 first.

Regardless of the size of the workbook, I almost automatically freeze panes. It helps Excel know you have a header row when you go to use the sort buttons.

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved

privacy policy