#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Print Problem

I have an Excel workbook that has 3 one-page worksheets in it and when I
print entire workbook; there is always an empty page after page 1. I have
looked at print preview and it does not show the blank page. I have selected
print 1 page width x 1 page long and put in a print area and it still prints
a blank page after the first worksheet page. Where is it getting this page
from??
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Print Problem

Go to:
View - Page Break Preview
and make sure the blue lines are just to the right and below the printable
data.

"Loretta" wrote:

I have an Excel workbook that has 3 one-page worksheets in it and when I
print entire workbook; there is always an empty page after page 1. I have
looked at print preview and it does not show the blank page. I have selected
print 1 page width x 1 page long and put in a print area and it still prints
a blank page after the first worksheet page. Where is it getting this page
from??

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Print Problem

View the workbook by worksheet in the page break view This will tell you what
is selected to print and all you have to do is move the blue lines to what
you wish to print. toolbar; view ; page break.


"Loretta" wrote:

I have an Excel workbook that has 3 one-page worksheets in it and when I
print entire workbook; there is always an empty page after page 1. I have
looked at print preview and it does not show the blank page. I have selected
print 1 page width x 1 page long and put in a print area and it still prints
a blank page after the first worksheet page. Where is it getting this page
from??

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Print Problem

It only shows the one page with the blue solid lines around it.

"Woofaloo" wrote:

View the workbook by worksheet in the page break view This will tell you what
is selected to print and all you have to do is move the blue lines to what
you wish to print. toolbar; view ; page break.


"Loretta" wrote:

I have an Excel workbook that has 3 one-page worksheets in it and when I
print entire workbook; there is always an empty page after page 1. I have
looked at print preview and it does not show the blank page. I have selected
print 1 page width x 1 page long and put in a print area and it still prints
a blank page after the first worksheet page. Where is it getting this page
from??

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
Print separate reports with same column heading [email protected] Excel Discussion (Misc queries) 4 September 1st 06 09:46 PM
print spreadsheet with each coming day dated on it for 2006. Megan Excel Discussion (Misc queries) 20 March 13th 06 09:02 PM
How can I print current row in same place on paper but not print surrounding cells??? Andy Ford New Users to Excel 1 September 2nd 05 05:50 AM
changing print area in an entire workbook lschuh Excel Worksheet Functions 7 August 4th 05 02:52 PM
In Excel print area setup problem with 2 different computers with. Rafi Setting up and Configuration of Excel 1 December 22nd 04 10:44 AM


All times are GMT +1. The time now is 11:43 AM.

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

About Us

"It's about Microsoft Excel"