MS - Print - Headers
 

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

MS - Print - Headers
 

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Dave" wrote:

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

MS - Print - Headers
 

FilePage SetupSheetRows to repeat at top.

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


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 13:45:02 -0800, Dave wrote:

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

MS - Print - Headers
 

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


"Gord Dibben" wrote:

FilePage SetupSheetRows to repeat at top.

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


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 13:45:02 -0800, Dave wrote:

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

MS - Print - Headers
 

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 wrote:

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

"Gord Dibben" wrote:

FilePage SetupSheetRows to repeat at top.

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


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 13:45:02 -0800, Dave wrote:

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 Peterson

MS - Print - Headers
 

thanks
--
Dave


"Dave Peterson" wrote:

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 wrote:

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

"Gord Dibben" wrote:

FilePage SetupSheetRows to repeat at top.

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


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 13:45:02 -0800, Dave wrote:

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 Peterson