How do I get rid of all of the blank pages?

S

stkelly52

Firstly, I am a Newb with Excel. I know how to do basic sorting an
what not, but I havn't ever done anything with marcos.

I have a document that has 9 pages of data, and then 25 pages of blan
cells. I have tried highlighting all of the blank stuff and clickin
on the delete rows button, and I have tried going to edit and delet
with it as well. I know that I can just hightlight everything I wan
and do a print selection, but it seems like I shouldn't have to
 
E

Eddie

hi: stkelly52

I have a easy way to get ride of all blank cells.
If you have all blank cells in one pages, you can do following

1. Ctrl+A
2. Ctrl+G
3. select click "special" in pop up window
4. check select "blanks"
5. right click "delete"
6 you can select delete cells or entire row.
 
J

John James

hi: stkelly52

Your question is about deleting pages, not cells, so previous responses
have missed the mark.

Backup your file before deleting sheets, because these steps cannot be
undone. (otherwise make sure you don't save the file if it doesn't give
what you want)

To delete a single sheet, use the right-mouse button on your mouse to
click on the sheet tab at the bottom of the page. From the menu which
appears, select delete sheet.

To delete multiple sheets, highlight these sheets first by holding the
ctrl key while you click on the sheet tabs with the left mouse button,
then follow the instructions in the previous paragraph.
 
D

Don Guillett

Methinks that you missed the vague point. OP probably meant pages with view
set to "page break preview". Read it again.
 
Top