Printing with the Headers showing on every page
 

How do I print a large spreadsheet where the column headers show up on every
printed page?


--
Dave

Printing with the Headers showing on every page
 

File Page Setup, click on the Sheet tab, then in the "Rows to Repeat at
Top' indicate which rows comprise your header (ex: $1:$1).

"Dave" wrote:

How do I print a large spreadsheet where the column headers show up on every
printed page?


--
Dave

Printing with the Headers showing on every page
 

What if that's grayed out? How do I do that then?

--
Dave


"bpeltzer" wrote:

File Page Setup, click on the Sheet tab, then in the "Rows to Repeat at
Top' indicate which rows comprise your header (ex: $1:$1).

"Dave" wrote:

How do I print a large spreadsheet where the column headers show up on every
printed page?


--
Dave

Printing with the Headers showing on every page
 

Did you get to the setup via Print Preview Setup or from File Page Setup?
I always see it grayed out if I get there from Preview, but not from File
Page Setup.

"Dave" wrote:

What if that's grayed out? How do I do that then?

--
Dave


"bpeltzer" wrote:

File Page Setup, click on the Sheet tab, then in the "Rows to Repeat at
Top' indicate which rows comprise your header (ex: $1:$1).

"Dave" wrote:

How do I print a large spreadsheet where the column headers show up on every
printed page?


--
Dave