ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Heading at the top of page... (https://www.excelbanter.com/excel-worksheet-functions/66258-heading-top-page.html)

J5

Heading at the top of page...
 
Is it possible to get the headings on the top of the first page to print on
the top of each page?

mphell0

Heading at the top of page...
 

Go to FilePage Setup, on the Sheet tab go to "Rows to Repeat at Top"
and select the desired rows.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=503011


Duke Carey

Heading at the top of page...
 
Use the menu to Choose File-Page Setup
Navigate to the Sheet tab and in the 2d box indicate the rows you want to
print at the top of each page

"J5" wrote:

Is it possible to get the headings on the top of the first page to print on
the top of each page?


Colin G

Heading at the top of page...
 
Does anybody know whether it is possible to apply this to certain pages only.
For example, I have a fairly lengthy table which prints on several pages so I
want headings to appear on each page, I therefore do as has been pointed out
in this thread. But at the bottom of the table I have a number of notes which
run on to more than one page when printed, I therefore do not want the table
headings appearing on a printed page which only has notes on it.


All times are GMT +1. The time now is 10:54 PM.

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