(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
(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
(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
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