ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   content does not stay in page break (https://www.excelbanter.com/excel-worksheet-functions/12520-content-does-not-stay-page-break.html)

notexcellent

content does not stay in page break
 
I am reapeating pages in a document (invoices). The content of each page runs
over the page break. Each time I the document, I cut and paste content so it
fits inside each page break, and save. Then when I reopen the doc, the page
break is uneven again (content runs over into the other page). I also tried
repositioning the page break!

nbrcrunch


1. Select the range that defines everything you want printed on one
page
2. File - PrintArea - Set Print Area
3. File - Page Setup
4. On the Setup pane, select: Fit to 1 page wide by 1 page tall.
5. Save the file
6. Print


--
nbrcrunch


All times are GMT +1. The time now is 05:39 PM.

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