How do I keep a heading on screen constantly in Office 2000?

M

mcjeffs

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

White space above heading inconsistently applied 1
Automation of scanned file storage based on content 0
Word doc keeps changing to ALL CAPS 0
"Fields Nested Too Deeply" Error in Simple Word Document 5
New computer, how do i move outlook 365 ENTIRELY? 0
Can i upgrade Office 2019 professional plus to office 2021 professional plus? 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Office 365 Outlook adding unwanted HTML to Email Body 0

Top