How do I delete all but one page on a worksheet?
 

I am working on an excell worksheet that has many unwanted pages. I have
tryed to delet the rows and colums, but it keeps expanding the rows. I am to
over 12,000 rows...I just need one page with 38 rows. I know how to print
just the one page, but I need to post this spreadsheet on my website.

How do I delete all but one page on a worksheet?
 

- Select the first sheet to be deleted
- Press and hold shift while selecting the last sheet to be deleted
- Right click on the selected sheets and select 'delete'


--
protonLeah


------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=548849

How do I delete all but one page on a worksheet?
 

"L. McD" <L. wrote in message
...
I am working on an excell worksheet that has many unwanted pages. I have
tryed to delet the rows and colums, but it keeps expanding the rows. I am
to
over 12,000 rows...I just need one page with 38 rows. I know how to print
just the one page, but I need to post this spreadsheet on my website.

If all of your cells are contiguous, select the range of your cells to
print, then file/print area/set print area. Hide the rows you don't need if
necessary.

Consider a cut/paste into a Word document, with link, and save as html...

Beege