Office 2007 - Excel

J

Janice

I hope I'm in the correct NG.

I have a spreadsheet that is several pages long when I print it.

Question: How do I get the column headers to appear at the top of each
printed page?

I've been at this for a day and cannot figure it out.

Thank you for your assistance.
Janice
 
G

Gordon

Janice said:
I hope I'm in the correct NG.

I have a spreadsheet that is several pages long when I print it.

Question: How do I get the column headers to appear at the top of each
printed page?

I've been at this for a day and cannot figure it out.

Thank you for your assistance.
Janice
Click to expand...


Umm on the Ribbon have you tried Page Layout-Print Titles?
 
J

Janice

Umm on the Ribbon have you tried Page Layout-Print Titles?
Click to expand...

In Page Layout | Page Setup > when I select the Sheet tab, the only
option in the Print section is "Row and column headings."
I don't want "rows." Print preview indicates that this just prints the
row numbers on each page.
I only want the column headings to print.
Grrrrrrrrrrrrrrrr!!!!

Thank you for the reply and help.
Janice
 
Top