| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete pages in a worksheet?
I am using only 1 worksheet in an Excel workbook but that single worksheet
has 23 pages in it. I only want the first three or four pages. How do I delete the remaining 20 pages? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I delete pages in a worksheet?
Right-click on the tab, and select 'Delete'.
HTH "Gretchen" wrote: I am using only 1 worksheet in an Excel workbook but that single worksheet has 23 pages in it. I only want the first three or four pages. How do I delete the remaining 20 pages? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I delete pages in a worksheet?
If you mean printed pages, just reset the print area to suit.
If the extra "pages" are just blank rows below your data, you can reset the used range by selecting row below your data. SHIFT + End + DownArrow. EditDeleteEntire Rows. Save the workbook and your used range will be reset. Gord Dibben MS Excel MVP On Thu, 3 Apr 2008 09:41:00 -0700, Gretchen wrote: I am using only 1 worksheet in an Excel workbook but that single worksheet has 23 pages in it. I only want the first three or four pages. How do I delete the remaining 20 pages? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to delete empty pages in my worksheet | Excel Discussion (Misc queries) | |||
| Easiest and quickiest way to delete blank pages in a worksheet | Excel Discussion (Misc queries) | |||
| How do I delete extra blank pages from an excel worksheet? | Excel Worksheet Functions | |||
| How do I delete or remove additional blank pages of a worksheet? | Excel Worksheet Functions | |||
| How do I delete pages 4 through 48 of my worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
