Merge - Unmerge
 

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?

Merge - Unmerge
 

Yes
Just select all the cells (Ctrl A)

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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=508075