ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Remove pages? (https://www.excelbanter.com/excel-worksheet-functions/14454-remove-pages.html)

Asniawasis

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

Fredrik Wahlgren


"Asniawasis" wrote in message
...
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




Fredrik Wahlgren


"Asniawasis" wrote in message
...
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




Gord Dibben

If by "pages" you mean printed pages on one sheet, just reduce your print
range to the 10 pages via FilePrint AreaSet 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
EditDelete.

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

On Tue, 22 Feb 2005 22:09:56 +0100, "Fredrik Wahlgren"
wrote:


"Asniawasis" wrote in message
...
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




Akbar Rafeek

Remove pages?
 


"Asniawasis" wrote:

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


Akbar Rafeek

Remove pages?
 


"Asniawasis" wrote:

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


RagDyeR

Remove pages?
 
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!
================================================== ===

"Akbar Rafeek" wrote in message
...


"Asniawasis" wrote:

I have a 'document' which shows 294 pages, I have only 10 actual pages.

How
can I delete or remove the unwanted pages?




Akbar Rafeek

Remove pages?
 


"Asniawasis" wrote:

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


Akbar Rafeek

Remove pages?
 


"Akbar Rafeek" wrote:

How can I delete blank pages in a document?

"Asniawasis" wrote:

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



All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com