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
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