Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

When printing, I get 5 extra blank pages. How do I delete them?

2,612 views
Skip to first unread message

Ricochet

unread,
Jul 25, 2007, 3:18:01 PM7/25/07
to
When printing in Excel, I get 5 extra blank pages.
They are also in the print preview.
I've tried deleting rows and columns.
How do I delete the extra pages?

Pete_UK

unread,
Jul 25, 2007, 3:36:37 PM7/25/07
to
Go to File | Page Setup | Sheet tab and you can see the print area
defined - just edit this to suit the size of your data.

Hope this helps.

Pete

On Jul 25, 8:18 pm, Ricochet <Ricoc...@discussions.microsoft.com>
wrote:

Ricochet

unread,
Jul 25, 2007, 3:52:08 PM7/25/07
to
Thank you Pete
What I did was highlight the area I wanted to print, then right clicked and
selected print area and it got rid of the extra pages.

Pete_UK

unread,
Jul 25, 2007, 4:11:36 PM7/25/07
to
Thanks for feeding back.

Pete

On Jul 25, 8:52 pm, Ricochet <Ricoc...@discussions.microsoft.com>
wrote:

> > > How do I delete the extra pages?- Hide quoted text -
>
> - Show quoted text -


Mathias

unread,
Jan 16, 2009, 4:42:04 AM1/16/09
to
Hi!

Apparently this thread is old but I do have an issue which is realted to
this and of highg importance. I think this should be able to fix in a simple
way.

I'm creating a template which could be used of colegues of mine. In this
template I'm currently not sure wich pages that will be empty (no data, lines
or colour at all). This pages should automaticly not be printed. I hope this
could be fixed by a simple setting under "Print settings" such as "do not
print empty pages in the priniting range" but I can not find such choise.

Happy for a solution.

Regards
Mathias

Dave Peterson

unread,
Jan 16, 2009, 8:20:48 AM1/16/09
to
What happens if you reset the print range so that excel determines what to
print?

Usually excel is smart enough to only print the used area.

--

Dave Peterson

CRUPPTED.EXE

unread,
Nov 20, 2009, 2:38:03 PM11/20/09
to
Mathias i have same problm..... My question is that how can we CONFIGURE
automatic page break in excel 2003, or how can we configure page break for
row or column to get prineted when new data will entred in formulated
fileds??? Automatic page break( Default ) is not working and manual page
break is not the permnt solution... while you are handling huge data.....
kindly rply soon if any excel wiz is here!!!!!!!!!!!!!!!!!!!!!!!!! :(
0 new messages