How to delete extra pages in Excel?

L

Longwell

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
 
S

Shane Devenshire

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.
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extra Excel Pages 4
need to delete empty pages in my worksheet 1
How to delete Blank lines in excel workbook? 2
How do I delete unwanted extra pages on Excel worksheets 4
Deleting extra rows in Excel 07 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
Delete extra pages in Excel 2007 2
Excel 2002: How to reveal the grid lines ? 2

Top