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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Count latest number of continous not-empty cells in a row. 11
Excel Add ^ to a row of cells containing letters 3
Inserting data to next available empty cells 2
Joining the contents of several cells into a single one 6
Find the first & subsequent cells to contain text in a column & re 28
Write a macro that hides rows based on empty cells 3
Can I delete a portion of cell contents repeating in multiple fie. 1

Top