Remove pages?

A

Asniawasis

I have a 'document' which shows 294 pages, I have only 10 actual pages. How
can I delete or remove the unwanted pages?
 
F

Fredrik Wahlgren

Asniawasis said:
I have a 'document' which shows 294 pages, I have only 10 actual pages. How
can I delete or remove the unwanted pages?

I assume you mean sheets. Right click on the sheet and a menu appears.
Select delete.

/Fredrik
 
F

Fredrik Wahlgren

Asniawasis said:
I have a 'document' which shows 294 pages, I have only 10 actual pages. How
can I delete or remove the unwanted pages?

I assume you mean sheets. Right click on the sheet and a menu appears.
Select delete.

/Fredrik
 
G

Gord Dibben

If by "pages" you mean printed pages on one sheet, just reduce your print
range to the 10 pages via File>Print Area>Set Print Area.

Alternatively, if the other 284 pages are blank........

Hit CTRL + End. Where does Excel take you? Excel easily gets confused about
where your data actually ends.

If far below your actual used range, select all rows below your used range and
Edit>Delete.

Same for columns to the right of the used range.

Now....IMPORTANT....Save the workbook. In some cases you may have to save and
close then re-open to see changes in used range.


Gord Dibben Excel MVP
 
R

RagDyeR

If you're talking about a single sheet, you can just reset the print area.

Select the entire area that you wish to print, then:

<File> <PrintArea> <Set PrintArea>

If there is *not supposed* to be anything (no data) beyond your print area,
check out this link of Debra's to resize your sheet:

http://www.contextures.com/xlfaqApp.html#Unused

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
 
Top