ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Print each record per page (https://www.excelbanter.com/excel-worksheet-functions/89656-print-each-record-per-page.html)

gabch

Print each record per page
 

Hi,

I have 200 records in worksheet with first row title.
How can I print each record with first row title per page without add
200 times pagebreak.

Best regards


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=543905


Pete_UK

Print each record per page
 
Adjust the top margin and/or bottom margin (easier to do this in print
preview) so that only one record and the title row fit into the space
on the page.

Hope this helps.

Pete



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

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