How do I print a large spreadsheet where the column headers show up on every printed page?
D Dave Nov 2, 2005 #1 How do I print a large spreadsheet where the column headers show up on every printed page?
B bpeltzer Nov 2, 2005 #2 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).
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).
B bpeltzer Nov 2, 2005 #4 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.
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.
