Merge - Unmerge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have received a large treasures report that i have to plough through, but
there are merged cells. is there s quick way to unmerge these cells instead
of trawling through the whole file?
 
Yes
Just select all the cells (Ctrl A)

then format cells alignment untick the merge cells box which wil
probably be gray

Regards

Da
 

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
Automatically color merged cells 1
How do I locate merged cells in my Excel worksheet? 7
How do I unmerge cells? 3
Pasting into merged cells 1
Merge 1
Problems sorting spreadsheet - Please Help 6

Back
Top