Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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

Re: DELETING EMPTY CELLS

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.