Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sharon
 
Posts: n/a
Default On an Excel Worksheet I want to view column headings as I scroll .

I am setting up a worksheet in Excel. I have column headings that I want to
be able to view as I scroll down the page(s). How do I do this?
  #2   Report Post  
Trevor Shuttleworth
 
Posts: n/a
Default

Sharon

activate a cell in column A in the row below the heading rows and
select Window | Freeze panes

If you select a cell in a column other than column A you can freeze the row
"headings" too so when you scroll to the right it leaves the left most
columns in view.

Regards

Trevor
"sharon" wrote in message
...
I am setting up a worksheet in Excel. I have column headings that I want
to
be able to view as I scroll down the page(s). How do I do this?



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 can i set consecutive columns in an excel worksheet to differ. Adam H Charts and Charting in Excel 2 February 25th 05 11:08 PM
My Excel column headers have changed to numbers, how do I get bac. Monty Excel Discussion (Misc queries) 3 February 18th 05 03:33 PM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM
How do I ROUNDUP a Column of cells on a worksheet template? house mouse Excel Worksheet Functions 2 December 16th 04 06:49 PM
Set up barcode column in Excel CareerPro-Naperville Resumes Excel Worksheet Functions 1 December 4th 04 05:37 AM


All times are GMT +1. The time now is 12:14 AM.

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

About Us

"It's about Microsoft Excel"