ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I keep blank pages from being included in header count? (https://www.excelbanter.com/excel-worksheet-functions/51458-how-do-i-keep-blank-pages-being-included-header-count.html)

R00ster

How do I keep blank pages from being included in header count?
 
The page count I set up in my header keeps counting blank pages at the end of
my sheet even after I have deleted those blank pages. How do I correct my
sheet so that my page count is correct?

Niek Otten

How do I keep blank pages from being included in header count?
 
Select the area you'd like to print and choose FilePrint AreaSet Print
Area

--
Kind regards,

Niek Otten

"R00ster" wrote in message
...
The page count I set up in my header keeps counting blank pages at the end
of
my sheet even after I have deleted those blank pages. How do I correct my
sheet so that my page count is correct?




R00ster

How do I keep blank pages from being included in header count?
 
I tried setting the print area but the blank pages at the end of the sheet
still print out and the header still includes them in the page count. I'm
baffled...

"R00ster" wrote:

The page count I set up in my header keeps counting blank pages at the end of
my sheet even after I have deleted those blank pages. How do I correct my
sheet so that my page count is correct?


R00ster

How do I keep blank pages from being included in header count?
 
I tried that already but thanks for trying to help me. The 2 blank pages
still print even after I set the print area to ignore them and even if they
did not print, the header still includes them in the page count. I'm
baffled...I think the answer lies in being able to delete those pages from
the sheet but I've tried several times and they still just won't go away.
HELP!

"Niek Otten" wrote:

Select the area you'd like to print and choose FilePrint AreaSet Print
Area

--
Kind regards,

Niek Otten

"R00ster" wrote in message
...
The page count I set up in my header keeps counting blank pages at the end
of
my sheet even after I have deleted those blank pages. How do I correct my
sheet so that my page count is correct?






All times are GMT +1. The time now is 10:19 AM.

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