How do I delete pages in a worksheet?
 

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?

How do I delete pages in a worksheet?
 

Right-click on the tab, and select 'Delete'.

HTH

"Gretchen" wrote:

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?

How do I delete pages in a worksheet?
 

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.

EditDeleteEntire Rows.

Save the workbook and your used range will be reset.


Gord Dibben MS Excel MVP

On Thu, 3 Apr 2008 09:41:00 -0700, Gretchen
wrote:

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?