ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel-copy first row onto each page ok but not last page How? (https://www.excelbanter.com/excel-discussion-misc-queries/31813-excel-copy-first-row-onto-each-page-ok-but-not-last-page-how.html)

Astro

Excel-copy first row onto each page ok but not last page How?
 
In excel using page set up I copy first line of workshheet to each page
printed as column headings but want it to not print on the last two pages
when printed out. thanks

Bryan Hessey


One way is to save and print the document, then amend the setting to
no-headers and with 'print pages', enter the page number of the last
two pages.

not a pretty idea though


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=381094



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

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