Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default Print preview/page set-up is printing 100's of blank pages

I am trying to print a small worksheet in excel and when I highlight the
cells, select print area and click on "fit to one page wide and one page
tall", it makes each single cell as one page and my print job is 1XXX pages
long. Any ideas on how to fix this? I already tried clearing print area,
resetting page breaks etc? It just started to happen maybe a few days ago
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Print preview/page set-up is printing 100's of blank pages

might be annoying but you could select what you want printed and choose
"print selection" when you want to print. or change view to print preview
and move the blue borders around.

"edwin" wrote:

I am trying to print a small worksheet in excel and when I highlight the
cells, select print area and click on "fit to one page wide and one page
tall", it makes each single cell as one page and my print job is 1XXX pages
long. Any ideas on how to fix this? I already tried clearing print area,
resetting page breaks etc? It just started to happen maybe a few days ago

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 79
Default Print preview/page set-up is printing 100's of blank pages

go to your last row and hit Ctrl/Shift and arrow key down this will select
all rows below and hit delete. now go to your last colum and hit Ctrl/Shift
and arrow right this will select all colums to the right of your work area
and hit delete. If there is anything in this area that your printer was
looking for this should remove it
--
grizz


"edwin" wrote:

I am trying to print a small worksheet in excel and when I highlight the
cells, select print area and click on "fit to one page wide and one page
tall", it makes each single cell as one page and my print job is 1XXX pages
long. Any ideas on how to fix this? I already tried clearing print area,
resetting page breaks etc? It just started to happen maybe a few days ago

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does text on page 3 not display in print preview and printing Elle Bea Excel Discussion (Misc queries) 1 February 16th 09 01:19 AM
my excel document is printing blank pages after every page ct Excel Discussion (Misc queries) 2 November 25th 08 04:31 PM
how do I fix printing-able to see as preview, but print out blank Zum Excel Discussion (Misc queries) 0 November 5th 07 02:46 PM
i get a blank page when i request a print preview ? wally1932 Setting up and Configuration of Excel 1 May 21st 07 09:18 PM
how do I print a range without printing the blank pages? Chris VP Excel Discussion (Misc queries) 2 May 2nd 05 07:08 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"