MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Keeping Rows A&B


Posted by Jea on December 06, 2001 8:15 PM

Rows A & B include my collumn headers. C on... is my data. How do I keep A & B as headers of each page when I print?

Thanks!


Posted by Bariloche on December 06, 2001 9:47 PM

Jea,

Go to File > Page SetUp > Sheet and enter the rows and columns you want to print on each page< like so:

rows: 1:1
columns: A:B

Don't enter the words "rows" and "columns", of course, but use that syntax.

enjoy