Freeze Headings?
 

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

Freeze Headings?
 

This may be the only chance I get to answer a question in this forum, Tx.
Click in A2
On the top menu: Window freeze panes.

"Doug Mc" wrote:

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

Freeze Headings?
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Doug Mc" wrote:

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