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

Firstly, I am a Newb with Excel. I know how to do basic sorting and 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 blank cells. I have tried highlighting all of the blank stuff and clicking on the delete rows button, and I have tried going to edit and delete with it as well. I know that I can just hightlight everything I want and do a print selection, but it seems like I shouldn't have to.

SAVE! after deleting the rows

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"stkelly52" <stkelly52.26a1vb_1145056804.649@excelforum-nospam.com> wrote in
message news:stkelly52.26a1vb_1145056804.649@excelforum-nospam.com...
>
> Firstly, I am a Newb with Excel. I know how to do basic sorting and
> 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 blank
> cells. I have tried highlighting all of the blank stuff and clicking
> on the delete rows button, and I have tried going to edit and delete
> with it as well. I know that I can just hightlight everything I want
> and do a print selection, but it seems like I shouldn't have to.
>
>
> --
> stkelly52
> ------------------------------------------------------------------------
> stkelly52's Profile:
> http://www.excelforum.com/member.php...o&userid=33519
> View this thread: http://www.excelforum.com/showthread...hreadid=533073
>

And if that doesn't work, Save As to itself.

"Don Guillett" wrote:

> SAVE! after deleting the rows
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "stkelly52" <stkelly52.26a1vb_1145056804.649@excelforum-nospam.com> wrote in
> message news:stkelly52.26a1vb_1145056804.649@excelforum-nospam.com...
> >
> > Firstly, I am a Newb with Excel. I know how to do basic sorting and
> > 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 blank
> > cells. I have tried highlighting all of the blank stuff and clicking
> > on the delete rows button, and I have tried going to edit and delete
> > with it as well. I know that I can just hightlight everything I want
> > and do a print selection, but it seems like I shouldn't have to.
> >
> >
> > --
> > stkelly52
> > ------------------------------------------------------------------------
> > stkelly52's Profile:
> > http://www.excelforum.com/member.php...o&userid=33519
> > View this thread: http://www.excelforum.com/showthread...hreadid=533073
> >
>
>
>

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.









stkelly52 wrote:
> Firstly, I am a Newb with Excel. I know how to do basic sorting and
> 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 blank
> cells. I have tried highlighting all of the blank stuff and clicking
> on the delete rows button, and I have tried going to edit and delete
> with it as well. I know that I can just hightlight everything I want
> and do a print selection, but it seems like I shouldn't have to.
>
>
> --
> stkelly52
> ------------------------------------------------------------------------
> stkelly52's Profile: http://www.excelforum.com/member.php...o&userid=33519
> View this thread: http://www.excelforum.com/showthread...hreadid=533073

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.

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"John James" <John.James.26abla_1145069401.1971@excelforum-nospam.com> wrote
in message news:John.James.26abla_1145069401.1971@excelforum-nospam.com...
>
> 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.
>
>
> --
> John James
> ------------------------------------------------------------------------
> John James's Profile:
> http://www.excelforum.com/member.php...o&userid=32690
> View this thread: http://www.excelforum.com/showthread...hreadid=533073
>