Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Floating Column Names.

Hi folks am after your brains again. I have a sheet with well over 500 rows.
Is there a way to float the column headings so I canh see them at whatever
row I am on.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Floating Column Names.

See Freeze Panes in Help.

Nevyn wrote:

Hi folks am after your brains again. I have a sheet with well over 500 rows.
Is there a way to float the column headings so I canh see them at whatever
row I am on.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Floating Column Names.

Click on the row below your headers, then go to view on the toolbar click
freeze panes.

"Nevyn" wrote:

Hi folks am after your brains again. I have a sheet with well over 500 rows.
Is there a way to float the column headings so I canh see them at whatever
row I am on.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Floating Column Names.

Thank you appreciated oh wise one.

"Column references within formulas" wrote:

Click on the row below your headers, then go to view on the toolbar click
freeze panes.

"Nevyn" wrote:

Hi folks am after your brains again. I have a sheet with well over 500 rows.
Is there a way to float the column headings so I canh see them at whatever
row I am on.

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
How do I create a floating column? Selda Excel Worksheet Functions 3 October 31st 11 01:53 PM
Create a floating cell that totals a column of numbers doffavoffid Excel Discussion (Misc queries) 1 October 4th 08 03:45 AM
Cluster Column Chart with floating gap Xtian Charts and Charting in Excel 1 November 15th 07 03:53 PM
How to Combine a Floating Column Chart with Line? silver23 Charts and Charting in Excel 1 August 9th 06 10:36 AM
Floating column chart Gian Charts and Charting in Excel 2 January 12th 05 02:48 AM


All times are GMT +1. The time now is 05:39 PM.

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"