How do I delete pages in a worksheet?

  • Thread starter Thread starter Gretchen
  • Start date Start date
G

Gretchen

I am using only 1 worksheet in an Excel workbook but that single worksheet
has 23 pages in it. I only want the first three or four pages. How do I
delete the remaining 20 pages?
 
If you mean printed pages, just reset the print area to suit.

If the extra "pages" are just blank rows below your data, you can reset the used
range by selecting row below your data.

SHIFT + End + DownArrow.

Edit>Delete>Entire Rows.

Save the workbook and your used range will be reset.


Gord Dibben MS Excel MVP
 

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

Back
Top