Floating Column Headers with Screen View

S

sansbugp

Version: 2008 How do I set my column headings to stay at the top of my viewing screen when I scroll down?
 
A

AlanMac

1 Go to View menu and select Normal.
2. Select cell below the row you want to freeze
3. On the Window menu click Freeze Panes

A wee bit different to windows version

Alan
 
C

CyberTaz

Further to Alan's reply, the position of the cell selector when you activate
Freeze Panes determines columns to be fixed on the left as well as rows
above. If you don't want to have any frozen columns make sure to select a
cell in Column A before applying the Freeze.

You may also be interested in the Split feature available from the same
Window menu. Information on both is available in Excel Help.
 

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

Reading view 1
Printing Outline view - formatting lost 0
Corrupt? Scrolling while viewing two pages side by side, pages go wonky? 0
Format column widths from one table to a separate table on same page 1
Mis-performing MP4 files in Mac PPT 1
Presentation on 2nd screen without presenter view 0
I'm John, My first post. 0
Excel 2008 unwanted scrolling 1

Top