How do I delete a page in Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 19 Dec 2005 22:29 GMT

I have a 5 page report I created in Excel. I want to delete the
last 2 pages (page 4 and 5 of 5).

Thanks, Paul...

Reply to this Message

Don Guillett - 19 Dec 2005 22:35 GMT

hold down the ctrl key>select both>right click>delete.
record a macro while doing.

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I have a 5 page report I created in Excel. I want to delete the
> last 2 pages (page 4 and 5 of 5).
>
> Thanks, Paul...

Reply to this Message

George Gee - 19 Dec 2005 22:35 GMT

Paul

Right-click the sheet tab > 'Delete'.

George

> I have a 5 page report I created in Excel. I want to delete the
> last 2 pages (page 4 and 5 of 5).
>
> Thanks, Paul...

Reply to this Message

David McRitchie - 20 Dec 2005 00:12 GMT

On the otherhand if you want to leave you Excel file intact, when you
print via File, Print,
your print driver probably let you print pages 1-3
you can check ahead of time witht he help of Print Preview.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> I have a 5 page report I created in Excel. I want to delete the
> last 2 pages (page 4 and 5 of 5).
>
> Thanks, Paul...

Reply to this Message

Gord Dibben - 20 Dec 2005 01:20 GMT

Paul

What do you consider a "page" to be?

A worksheet?

A page that would be part of a printed area on one worksheet?

George has given you a method of deleting a worksheet.

If you have 5 printed pages on one sheet, you could simply delete the rows you
don't want or change the print area to exclude those rows.

Gord Dibben Excel MVP

>I have a 5 page report I created in Excel. I want to delete the
>last 2 pages (page 4 and 5 of 5).
>
>Thanks, Paul...

Reply to this Message