There are a lot of blanc cells in a worksheet, and now I want to select all
of them, delete and shift cells left. is there a function to realize it? or
macro?

Thank you~

Select the range
edit|goto|special|blanks
Edit|delete (shift left)

If you need a macro, you can record one when you do it manually.

tiramisu wrote:
>
> There are a lot of blanc cells in a worksheet, and now I want to select all
> of them, delete and shift cells left. is there a function to realize it? or
> macro?
>
> Thank you~

--

Dave Peterson

Hit function key F5

Special>Blanks>OK

This will select all blank cells in the used range.

Then:

Edit>Delete>Shift cells left>OK

Biff

"tiramisu" <(E-Mail Removed)> wrote in message
news:51135B75-F01D-4A11-844B-(E-Mail Removed)...
> There are a lot of blanc cells in a worksheet, and now I want to select
> all
> of them, delete and shift cells left. is there a function to realize it?
> or
> macro?
>
> Thank you~
>