DELETING EMPTY CELLS
Posted by Jason on December 23, 2001 9:08 PM
How do i delete (and shift cells left) a large selection of cells making all blank ones dissapear or alternativley.
how do i arange all a datasheet so
a b c
a b c d
a b c d e
a
a b
all of the last pieces of data are place into a single row
a b c
a b c d
a b c d e
a
a b
so it looks like above
Posted by Gary Bailey on December 24, 2001 4:07 AM
If I've understood your question correctly try Edit->GoTo->Special->Blanks which should select all the empty cells.
Then right click Delete->Shift cells left.
Gary
