Repeat Top Row in All Printed Pages

May 25, 2003 - by Bill Jelen

Roberto asks,

I have a row of headings at the top of my spreadsheet. How can I make this row appear at the top of each page when I print out the spreadsheet?

From the menu, select File then Page Setup.

In the Page Setup dialog, there are four tabs across the top. Select the Sheet tab. In the field for Rows to repeat at top:, enter 1:1

This will cause row 1 to appear at the top of each printed page.