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