Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 42
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 857
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 freeze panes won't freeze top row only macbone2002 Excel Discussion (Misc queries) 3 April 22nd 23 02:07 AM
Worksheet has numeric column headings. Change to alpha headings? Be Frank Excel Discussion (Misc queries) 1 June 18th 08 04:22 PM
freeze pane: freeze from two worksheets? Chris Excel Discussion (Misc queries) 4 May 27th 08 01:17 AM
Column headings to numbers and row headings to alphabets? Juliana Excel Discussion (Misc queries) 2 May 9th 08 05:58 PM
Can I invert a table so row headings are now column headings etc Sharon Excel Worksheet Functions 3 February 10th 05 07:28 PM


All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"