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

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

    software

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

    E-mail轉寄