Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
RogerD
 
Posts: n/a
Default How do I delete unwanted extra pages on Excel worksheets

I have a worksheet in Excel which I do scheduling with. I keep getting the
Header printed out on it, and then as a page 2. I don't see how to delete the
page two on the worksheet as it doesn't show. But will print. How do I delete
that second page in the worksheet? Am using Microsoft Office Pro 2003.
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m
 
Posts: n/a
Default How do I delete unwanted extra pages on Excel worksheets

There are probably cells with blank spaces in them below the end of your
data. What I do when this happens is I do a print preview, then go back onto
the sheet and highlight a whole bunch of blank rows just under the 1st page
break. This will usually get rid of any blank spaces and thus shoyuld only
print your one page of data.

"RogerD" wrote:

I have a worksheet in Excel which I do scheduling with. I keep getting the
Header printed out on it, and then as a page 2. I don't see how to delete the
page two on the worksheet as it doesn't show. But will print. How do I delete
that second page in the worksheet? Am using Microsoft Office Pro 2003.

  #3   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default How do I delete unwanted extra pages on Excel worksheets

There are instructions here for manually or programmatically reseting
the used range:

http://www.contextures.com/xlfaqApp.html#Unused

That should prevent unused pages from printing

RogerD wrote:
I have a worksheet in Excel which I do scheduling with. I keep getting the
Header printed out on it, and then as a page 2. I don't see how to delete the
page two on the worksheet as it doesn't show. But will print. How do I delete
that second page in the worksheet? Am using Microsoft Office Pro 2003.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #4   Report Post  
Posted to microsoft.public.excel.misc
broro183
 
Posts: n/a
Default How do I delete unwanted extra pages on Excel worksheets


Hi Roger,

To see where the page breaks are, change the view to "pagebreak
preview" [alt + v + p]. The blue lines that appear show the edges of
your pages & can be dragged with the mouse to suit.
Another approach is to clear the existing print area [alt + f + t + c],
select the range you want printed & set the print area [alt + t + s].

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=544002

  #5   Report Post  
Posted to microsoft.public.excel.misc
broro183
 
Posts: n/a
Default How do I delete unwanted extra pages on Excel worksheets


Ooopps!

The shortcut for setting the print area should be [alt + f + t + s] (in
my version of excel anyway).

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=544002

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
Overview Improvements for Excel Worksheets Feda Excel Discussion (Misc queries) 5 September 18th 07 10:08 PM
How do I delete extra blank pages from an excel worksheet? Satiricalbliss Excel Worksheet Functions 3 April 18th 06 09:23 PM
How to compress an Excel file once deleting extra worksheets Sandals Excel Discussion (Misc queries) 0 March 2nd 06 04:28 PM
How do you protect hidden linked worksheets with in an Excel workb Newsgal Excel Discussion (Misc queries) 1 February 21st 06 09:49 PM
How do I delete 2000 pages created by Excel from my one page doc. crmlcat Excel Worksheet Functions 2 April 27th 05 04:54 PM


All times are GMT +1. The time now is 01:51 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"