ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Extra Blank Pages In Preview (https://www.excelbanter.com/new-users-excel/84620-extra-blank-pages-preview.html)

Smooth

Extra Blank Pages In Preview
 
Getting blank pages in preview box after work even tho nothing is in there.
Any one got any ideas please thank you

Paul B

Extra Blank Pages In Preview
 
Smooth, sounds like excel thinks you have data even after you delete it,
have a look here for ways to reset the last cell

http://www.mvps.org/dmcritchie/excel/lastcell.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Smooth" wrote in message
...
Getting blank pages in preview box after work even tho nothing is in

there.
Any one got any ideas please thank you




Neto

Extra Blank Pages In Preview
 
If everything else fails, set the print area. At least you will not be
bothered with the blank pages!
--
Amateur


"Paul B" wrote:

Smooth, sounds like excel thinks you have data even after you delete it,
have a look here for ways to reset the last cell

http://www.mvps.org/dmcritchie/excel/lastcell.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Smooth" wrote in message
...
Getting blank pages in preview box after work even tho nothing is in

there.
Any one got any ideas please thank you





gls858

Extra Blank Pages In Preview
 
Smooth wrote:
Getting blank pages in preview box after work even tho nothing is in there.
Any one got any ideas please thank you


Check your margins. I've seen this happen when the margins are set
very close to the data so that some blank portion of the sheet
exceeds the margin thus printing a blank page. Symptom is a
blank page every other page.

gls858


All times are GMT +1. The time now is 09:50 PM.

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