Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
EricRod
 
Posts: n/a
Default Blank Worksheet Pages

How do I get rid of the blank pages at the end of my worksheet? I tried
using the File/Set Print Area command, but the empty pages still appear in my
page preview and also when I go to printout my worksheet.

Please advise.
--
Best regards,
EricRod
  #2   Report Post  
Ray A
 
Posts: n/a
Default

See what Deb Dalgleish has to say
http://www.contextures.com/xlfaqApp.html#Unused

"EricRod" wrote:

How do I get rid of the blank pages at the end of my worksheet? I tried
using the File/Set Print Area command, but the empty pages still appear in my
page preview and also when I go to printout my worksheet.

Please advise.
--
Best regards,
EricRod

  #3   Report Post  
Bill Ridgeway
 
Posts: n/a
Default

If you have spare space to the right -
Highlight all columns to the right of your last used column and click on
<Enter<Delete

If you have spare space below -
Highlight all rows below your last used row and click on <Enter<Delete

If you have empty worksheets -
Go into each of the empty spreadsheets and click on <Edit<Delete sheet

The default setup for Excel is to (quite unnecessarily) have 4 worksheets
open with each new spreadsheet. To reduce this overhead -
Click on <Tools<Options<General and change the "sheets in new
workbook [spreadsheet]" to 1.

Regards.

Bill Ridgeway
Computer Solutions

"EricRod" wrote in message
...
How do I get rid of the blank pages at the end of my worksheet? I tried
using the File/Set Print Area command, but the empty pages still appear in
my
page preview and also when I go to printout my worksheet.

Please advise.
--
Best regards,
EricRod



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
Varying page Excel report judypudy Excel Discussion (Misc queries) 6 July 13th 05 08:39 PM
Removing blank rows in a worksheet Louise Excel Worksheet Functions 6 May 26th 05 02:21 PM
Copying blank excel worksheet into additional excel workbooks Deb Excel Discussion (Misc queries) 10 February 4th 05 01:25 AM
Last non blank row in a worksheet gana Excel Worksheet Functions 9 January 31st 05 10:33 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 02:23 PM


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

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"