ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reproducing Data (https://www.excelbanter.com/excel-discussion-misc-queries/116635-reproducing-data.html)

Ross

Reproducing Data
 
Hi,

I'm tryin to print off several pages at a time and I want the data I have in
cells A1:C64 to be on every new page that is printed off. My required
printing runs from colums A - BL.
How do I do this without inseting my A1:C64 data several times into the
worksheet?

Many Thanks,
Ross


Andy Williams

Reproducing Data
 
Got to File-Page Setup
Select the Sheets tab
In the 'Rows to Repeat at Top' box enter $1:$64
In the 'Columns to Repeat at Left' box enter $A:$C

"Ross" wrote:

Hi,

I'm tryin to print off several pages at a time and I want the data I have in
cells A1:C64 to be on every new page that is printed off. My required
printing runs from colums A - BL.
How do I do this without inseting my A1:C64 data several times into the
worksheet?

Many Thanks,
Ross



All times are GMT +1. The time now is 07:09 PM.

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