Select the range then...........

F5SpecialBlanksOK

EditDeleteShift cells left

What do the letters A though D in Column A represent?


Gord Dibben MS Excel MVP


On Tue, 30 Dec 2008 12:33:33 -0800, PointerMan
wrote:

How do I eliminate the blank cells in my worksheet so that everything
essentially shifts to the left until the empty cells are gone?

I want this: To look like this:
A _ 5 1 _ 3 1 _ A 5 1 3 1
B 9 _ _ 1 2 1 9 B 9 1 2 1 9
C 3 1 2 _ _ 2 8 C 3 1 2 2 8
D _ _ 6 1 3 _ 2 D 6 1 3 2
* The _ represents the empty cells

Each value would still be in it's own cell, and the blanks would be gone.