MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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