ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to remove blanc pages (https://www.excelbanter.com/excel-worksheet-functions/160410-how-remove-blanc-pages.html)

ariette

how to remove blanc pages
 
My document contains 7 pages, however it keeps showing 14 pages. The page
numbering keeps going with 1 of 14, 2 of 14 etc. How can I delete the pages 8
till 14 so the printer doesn't give blanc pages and will print pages with
numbers 1 of 7, 2 of 7 etc.

Pete_UK

how to remove blanc pages
 
Move to the bottom of your data, then highlight the next row by
clicking on the row identifier. Hold down the <Shift key and press
<End once followed by <Down-Arrow, then release <Shift. Click on
Edit | Delete, and then save the file in order to reset where Excel
thinks the last used row is.

Hope this helps.

Pete

On Oct 2, 12:56 am, ariette wrote:
My document contains 7 pages, however it keeps showing 14 pages. The page
numbering keeps going with 1 of 14, 2 of 14 etc. How can I delete the pages 8
till 14 so the printer doesn't give blanc pages and will print pages with
numbers 1 of 7, 2 of 7 etc.





All times are GMT +1. The time now is 06:12 AM.

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