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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove preloaded-text upon creation of a new Word file? 0
AppleScript - How do I select a text ? 1
Table Header Cells keep shifting 8
Add numbers if cell fill is a certain color; How To? 5
Place picture in Excel cell 0
Difference of empty cell and zero value when formatting 4
Merging from an Excel file with graphics 1
Write a macro that hides rows based on empty cells 3

Top