ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Continued Column titles (https://www.excelbanter.com/excel-discussion-misc-queries/35313-continued-column-titles.html)

Radish

Continued Column titles
 
I have been given a very large spreadsheet with alot of data. I need the
column titles to print on every page. The freeze frames make it easy to read
all the data on the computer, but when printed off, the first page needs to
be near by to see what data is in each column. How would i go about making
rows 1 to 9 appear on EVERY printed page?

JP Jones

File Menu

Page Setup

Sheet Tab

Rows to repeat at top.... set to $1:$9




"Radish" wrote:

I have been given a very large spreadsheet with alot of data. I need the
column titles to print on every page. The freeze frames make it easy to read
all the data on the computer, but when printed off, the first page needs to
be near by to see what data is in each column. How would i go about making
rows 1 to 9 appear on EVERY printed page?



All times are GMT +1. The time now is 04:30 PM.

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