MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Unwanted pages in worksheet


Posted by Mary on August 08, 2001 4:24 PM

I have a worksheet that got some extraneous data (probably entered by me by mistake) numerous pages down. I have tried to select all the unwanted pages and delete them but I get an message saying I cannot delete multiple sections at one time. How can I delete these extra pages?


Posted by Cory on August 08, 2001 8:19 PM

Delete them one at a time?

Cory

Posted by anno on August 08, 2001 9:37 PM

I guess what you do depends on your needs. if this is causing a printing problem (ie. printing lots of blank pages because of unwanted data way down below) try resetting the print area - File menu, Set Print Area.
However if the unwanted data is causing other problems (increasing file size, formatting, etc) then deleting it is the way to go. It sounds you have tried that, but give this method a try:

If you are working on one worksheet only, go to the last row you have data you want to keep, select the row after that one, hold down the Ctrl and Shift key and hit the down arrow. This should select the whole sheet below the last row you want to keep. Then go to the Edit menu, select Clear|All (or right click to shortcut menu to clear all), then press the delete key. Go through the same process for all columns as well and that should do it. If you are using multiple worksheets, use the same procedure but group the sheets first by selecting your first sheet tab, holding down the Shift key and clicking on the last sheet tab (or right click to shortcut menu to select all sheets). When you group the sheets whatever change you make to one sheet you'll make to all the others, so make sure that you won't be deleting wanted data on any of the sheets beforehand.
Hope this helps

Posted by Mary on August 09, 2001 5:26 PM

Anno, Thanks for the help. Your suggestion worked great!