Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mcjeffs
 
Posts: n/a
Default How do I keep a heading on screen constantly in Office 2000?

I am trying to keep headings on a large spreadsheet on the screen while the
rest of the information can move. how can I do this?
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

click underneath (and to the right) of what you want to stay fixed (ie A2 if
you just want row 1 fixed, or B2 if you want row 1 and column A) and then
choose window / freeze panes. To undo, choose window / unfreeze panes

Cheers
JulieD

"mcjeffs" wrote in message
...
I am trying to keep headings on a large spreadsheet on the screen while the
rest of the information can move. how can I do this?



  #3   Report Post  
Chris Rogers
 
Posts: n/a
Default

Some people like to just use the split screen functionality as well.

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
Change color of startup screen Search Excel Discussion (Misc queries) 0 February 12th 05 06:47 PM
how do i centre headings accross the screen in excell? Sethius Excel Discussion (Misc queries) 1 February 1st 05 10:46 AM
Help screen NEWBIE From NOVA SCOTIA Excel Discussion (Misc queries) 1 December 21st 04 01:07 AM
How do I set up a column with a heading and a subheading? Chelle21 Excel Discussion (Misc queries) 1 November 29th 04 09:08 PM
How do I create a personalized heading row in excel (one that rea. questionsquestions Excel Worksheet Functions 2 November 9th 04 12:13 AM


All times are GMT +1. The time now is 02:19 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"