| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1st page only Headers & Footers | Excel Discussion (Misc queries) | |||
| Printing Recto/Verso | Excel Discussion (Misc queries) | |||
| If I change page margins headers don't line up??? | Excel Discussion (Misc queries) | |||
| Printing headers on all pages except the first | Excel Discussion (Misc queries) | |||
| Excel Web Page Printing | Excel Discussion (Misc queries) | |||
Linear Mode
