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...
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...
hold down the ctrl key>select both>right click>delete.
record a macro while doing.
--
Don Guillett
SalesAid Software
[email protected]
"Paul" <[email protected]> wrote in message
news:[email protected]...
>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...
Paul
Right-click the sheet tab > 'Delete'.
George
Paul wrote:
> 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...
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
"Paul" <[email protected]> wrote in message news:[email protected]...
> 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...
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
On Mon, 19 Dec 2005 14:29:03 -0800, "Paul" <[email protected]>
wrote:
>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...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks