Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
freeze pane: freeze from two worksheets? | Excel Discussion (Misc queries) | |||
Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |