ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I keep a heading on screen constantly in Office 2000? (https://www.excelbanter.com/new-users-excel/13145-how-do-i-keep-heading-screen-constantly-office-2000-a.html)

mcjeffs

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?

JulieD

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?




Chris Rogers

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



All times are GMT +1. The time now is 05:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com