ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print a certain row as the header on each page (https://www.excelbanter.com/excel-discussion-misc-queries/50317-print-certain-row-header-each-page.html)

Michelle

print a certain row as the header on each page
 
I would like to print the same row on each page as the top row. It is not
the top row on the first page.

MAX258


Michelle,

Go to File/Page Setup

Under Page Setup go the the Sheet tab

For the selection - Rows to repeat at top, go the cell reference and
select whatever row you want to repeat.

hope that helps.
Max


--
MAX258
------------------------------------------------------------------------
MAX258's Profile: http://www.excelforum.com/member.php...fo&userid=1538
View this thread: http://www.excelforum.com/showthread...hreadid=476017



All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com