MS - Print - Headers

[Dave]

If I have a long spread sheet and I want to print it and see the top three
rows on each sheet I print without having to insert those three rows over and
over again, how do I do that?

Office XP

 

[Dave F]

File--Page Setup, then click the Sheet tab, and in the field Rows to repeat
at top select the relevant rows.

Note that you can't access this via print preview.

Dave

 

[Gord Dibben]

File>Page Setup>Sheet>Rows to repeat at top.

Enter $1:$3 or just point to those three rows.


Gord Dibben MS Excel MVP

 

[Dave]

Dave, Gord,
Thanks, but now when I print I also see the A B C D etc... across the top.
I don't want that.

 

[Dave Peterson]

That's a different setting.

File|Page setup|Sheet tab|Uncheck Row and column headings

But this can be very useful when you're double checking data entry. (Kind of
ugly on the final report, though???)

 

[Dave]

thanks
--
Dave

That's a different setting.

File|Page setup|Sheet tab|Uncheck Row and column headings

But this can be very useful when you're double checking data entry. (Kind of
ugly on the final report, though???)