Freeze Headings?

D

Doug Mc

I'm having a Senior Moment!
I've completely fogotten how to make my worksheet headings permanent!
But I'm OLD!

Thanks for your help.
Doug
 
X

XLFanatico

This may be the only chance I get to answer a question in this forum, Tx.
Click in A2
 
S

Shane Devenshire

Hi,

This is a very useful command so I recommend that you add its toolbar button
to one of your toolbars: Choose View, Toolbars, Customize, Commands tab,
Window and Help Category and on the right find the Freeze Panes button and
drag it out to a toolbar.

To freeze titles place the cursor below the row and to the right of the
column you want to freeze. For example if you want rows 1 and 2 to stay
fixed but no columns put your cursor in A3. Freeze panes always occurs above
and to the left of the cursor.

In 2007 the command is View, Freeze Panes, Freeze Panes.
 
Top