| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to delete empty pages in my worksheet
I have created a 3 page excel worksheet, with custom headers and footers.
There are 2 extra pages to the worksheet that are only showing the headers and footers, but no data. These two extra pages need to be deleted, but I don't know how to do that. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to delete empty pages in my worksheet
Bailey
Couple of ways: 1) You can gotofileprint areaClearprint area, then select the entire area you want to print and go back through and this time select set print area. 2) Or you can gotoviewpage break preview, here you can hook onto the blue lines separating each page and move them to where you want them to break. Here you can also select the areas that you want to print and exclude others that you may not want to print. Either one works for me on xl2k. Mike Rogers "Bailey" wrote: I have created a 3 page excel worksheet, with custom headers and footers. There are 2 extra pages to the worksheet that are only showing the headers and footers, but no data. These two extra pages need to be deleted, but I don't know how to do that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easiest and quickiest way to delete blank pages in a worksheet | Excel Discussion (Misc queries) | |||
| how do i find and delete all empty rows in an excel worksheet | Excel Worksheet Functions | |||
| How do I delete extra blank pages from an excel worksheet? | Excel Worksheet Functions | |||
| How do I delete pages 4 through 48 of my worksheet? | Excel Discussion (Misc queries) | |||
| How do I delete an empty worksheet. | Excel Worksheet Functions | |||
Linear Mode
