Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a 'document' which shows 294 pages, I have only 10 actual pages. How
can I delete or remove the unwanted pages? |
#2
![]() |
|||
|
|||
![]() "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 |
#3
![]() |
|||
|
|||
![]() "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 |
#4
![]() |
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() "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? |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() "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? |
#7
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#8
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() "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? |
#9
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
numbering all pages in worksheet | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
How do I remove pages in Excel? | Excel Discussion (Misc queries) | |||
How do I delete pages? | Excel Discussion (Misc queries) |