How locate merged cells in Excel

G

Guest

I want to sort columns but some cells are merged. How do I locate the merged
cells - or is there a way of unmerging all merged cells?
 
G

Guest

Select all cells and hit the "merge" button, just like you were going to
merge those cells. If there are any merged cells within your workbook it
will unmerge them first.
 

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

Sharing workbooks limitations - Merged Cells 12
How do I locate merged cells in my Excel worksheet? 7
sorting two columns of merged cells 1
VBA set thick borders around non empty cells in range 0
Count with merged cells 2
Copying merged cells 2
trying to sort excel data. won't allow. merged cells sizing.?? 2
Automatically color merged cells 1

Top