Deleting blank cells AFTER an UNMERGE

T

Troy

Hello,

Is there a less labor intensive way to delete scattered blank cells as a
result of doing an unmerge?

My thanks,

Troy
 
G

Gord Dibben

F5>Special>Blanks>OK

Edit>Delete.........shift up or left


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

Protected sheet - attempt to delete row = unmerged cells 5
Retain value of merged cell in all unmerged cells 3
Merged Cells 0
Automatically color merged cells 1
separation of text and numbers in an unmerged cell 9
Pasting into merged cells 1
Transfering data from a .pdf file to word and then to excel 1
import csv data into a range with merged cells without unmerging 2

Top