WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to delete extra pages in Excel?

 
   Home -> Office -> General Discussions RSS
Next:  Export individual mail folders in Outlook '03  
Author Message
Longwell

External


Since: Mar 22, 2009
Posts: 1



(Msg. 1) Posted: Sun Mar 22, 2009 9:12 am
Post subject: How to delete extra pages in Excel?
Archived from groups: microsoft>public>excel>misc (more info?)

I HAD a three page worksheet in Excel 2007, with percentages calculated and
some lines shaded.
This suddenly became a 67 page worksheet!!! I THINK some of the shading
lines got extended nearly to to infinity.
Is there a way to delete the additional 64 (or so) unwanted pages?
Thanks for any help with this.
Larry
Back to top
Login to vote
Shane Devenshire

External


Since: Nov 11, 2008
Posts: 1059



(Msg. 2) Posted: Sun Mar 22, 2009 9:31 am
Post subject: RE: How to delete extra pages in Excel? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,

When you say pages, are you talking about Sheets or are you talking about
pages at printout?

1. Print only one page a printout, select the range you want to print and
choose Page Layout, Print Area, Set Print Area, or with the range selected
choose Office Button, Print, and turn on the Selection option.

2. You formatting probably extends to "infinity" because you probably
clicked the row number and then applied formatting, instead select the range
and apply the formatting. Set the rows' formats back to None and then
reformat the range.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Longwell" wrote:

> I HAD a three page worksheet in Excel 2007, with percentages calculated and
> some lines shaded.
> This suddenly became a 67 page worksheet!!! I THINK some of the shading
> lines got extended nearly to to infinity.
> Is there a way to delete the additional 64 (or so) unwanted pages?
> Thanks for any help with this.
> Larry
Back to top
Login to vote
Sheeloo

External


Since: Mar 13, 2009
Posts: 9



(Msg. 3) Posted: Sun Mar 22, 2009 9:33 am
Post subject: RE: How to delete extra pages in Excel? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Select the first blank row
Press END key
Press SHIFT-DOWN ARROW keys
Right-click and choose Delete
Save the workbook

Repeat for Columns, if required

"Longwell" wrote:

> I HAD a three page worksheet in Excel 2007, with percentages calculated and
> some lines shaded.
> This suddenly became a 67 page worksheet!!! I THINK some of the shading
> lines got extended nearly to to infinity.
> Is there a way to delete the additional 64 (or so) unwanted pages?
> Thanks for any help with this.
> Larry
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Help Forum Terms of Service |
  • Link to WUGNET |
  • IT Support