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

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copy Columns based on Header name 1
How to freeze a range in excel 2003and 2007 1
Pivot Chart Row and Column Headers 2
How do I apply a formula to a whole column at once? 3
Access Page Header with merge field 0
Excel title bar 1
cell header for each page print out 1

Top