How to delete all the blanc cells in a worksheet and shift cells l
 

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~

How to delete all the blanc cells in a worksheet and shift cells l
 

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

How to delete all the blanc cells in a worksheet and shift cells l
 

Hit function key F5

SpecialBlanksOK

This will select all blank cells in the used range.

Then:

EditDeleteShift cells leftOK

Biff

"tiramisu" wrote in message
...
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~