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

  • Thread starter Thread starter auctioncoach
  • Start date Start date
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
 
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
 
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
VBA set thick borders around non empty cells in range 0
I am stumped. Help with Formula... 5
display content of merged cells 1
how to copy the contents from last cell 2
Copy cell contents in empty rows below it till any unempty row com 1
Write a macro that hides rows based on empty cells 3
Difference of empty cell and zero value when formatting 4

Back
Top