ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I get my column titles to print at the top of 2nd page? (https://www.excelbanter.com/excel-worksheet-functions/113699-how-do-i-get-my-column-titles-print-top-2nd-page.html)

Vikki

How do I get my column titles to print at the top of 2nd page?
 
I want to repeat Row 3, Columns A-G at the top of each page when it prints.
How is that done?

Pete_UK

How do I get my column titles to print at the top of 2nd page?
 
In File | Page Setup select the Sheet tab and you will see a box Rows
to Repeat at Top - just enter your row(s) here. Ensure that you exclude
them from the print range, otherwise they will appear twice on the
first page.

Hope this helps.

Pete

Vikki wrote:
I want to repeat Row 3, Columns A-G at the top of each page when it prints.
How is that done?



Jim Thomlinson

How do I get my column titles to print at the top of 2nd page?
 
File - Page Setup - Sheet - Rows to Repeat at Top
--
HTH...

Jim Thomlinson


"Vikki" wrote:

I want to repeat Row 3, Columns A-G at the top of each page when it prints.
How is that done?



All times are GMT +1. The time now is 08:35 AM.

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