Force Column Headers On Each Page

J

John Persico

When you're viewing an Excel worksheet...
How do you make it so that you can always see the first row, no matter how
far down the down the document you are.

--
 
G

Gord Dibben

Select A2 and Window>Freeze Panes.

In 2007 that would be View>Freeze Panes


Gord Dibben MS Excel MVP
 

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

Creating Different Headers in Word 0
MS Word List Bug 0
Dealing with the error: unable to filter on excel hc home school 0
Two columns followed by single page-width column on same page 0
Format column widths from one table to a separate table on same page 1
How to make repeating drop-down lists? 2
Embedded Excel into Word with Tables 0
How to make scroll bar permanently visible, Word 365 0

Top