close

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 will
probably be gray

Regards

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()