Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Printing a header row on every page
2 views
Skip to first unread message
Amy
Nov 12, 2002, 12:42:24 PM11/12/02
to
I have a spreadsheet that prints on several pages. I've
created a row of headers on the first page and would like
this row to repeat at the top of every new page. Is there
a way to set something to automatically do this or will I
need to paste my row into the top of every page?
created a row of headers on the first page and would like
this row to repeat at the top of every new page. Is there
a way to set something to automatically do this or will I
need to paste my row into the top of every page?
Debra Dalgleish
Nov 12, 2002, 12:49:35 PM11/12/02
to
To repeat row(s) at the top of every printed page:
1. Choose File>Page Setup
2. Select the Sheet tab
3. Click in the 'Rows to repeat at top' box
4. On the worksheet, click the row button at the left side of the row(s)
you want at the top of each page
5. The row reference will be inserted in the dialog box, e.g.: $1:$1
6. Click OK
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Amy
Nov 12, 2002, 1:47:24 PM11/12/02
to
Thank you so much!>.
>
>
0 new messages