How to delete extra pages in Excel?
 

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

How to delete extra pages in Excel?
 

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

How to delete extra pages in Excel?
 

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