Prev: Automatically Transfer Info from one worksheet to another
Next: Formula Help
From: David Bateman on 19 Feb 2010 16:47
Could someone provide a macro that would unmerge and of the cell in excel
and then delete all of the blank cells. Thank you in advance!

Best,

David


From: Gord Dibben on 19 Feb 2010 17:03
With macro recorder turned on, CTRL + A to select all cells.

Format>Cells>Alignment.

Uncheck "merge cells" and OK

F5>Special>Blanks>OK

Edit>Delete>Shift Up or whatever.


Gord Dibben MS Excel MVP

On Fri, 19 Feb 2010 13:47:34 -0800, "David Bateman"
<davidbateman(a)charter.net> wrote:

>Could someone provide a macro that would unmerge and of the cell in excel
>and then delete all of the blank cells. Thank you in advance!
>
>Best,
>
>David
>

 | 
Pages: 1
Prev: Automatically Transfer Info from one worksheet to another
Next: Formula Help