how do I shift the contents of the cells up to remove empty cells.

A

auctioncoach

I have empty cells scattered throughout a row .
whenever I delete the contents of a cell it leaves it empty. I would like to
consolodate the information in the row so no empty cells are apparent
 
M

Max

For possibly better answers, elaborate further. Show us some sample data, and
the expected results. I'm having difficulty reconciling your subject line
with your description.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
 
G

Gord Dibben

F5>Special>Blanks>OK

Edit>Delete>Shift cell up.

May or may not be what you want.


Gord Dibben MS Excel MVP
 
Top