Select the respective columns with merged cells
right click on the mouse
choose Format Cells
select Alignment
under Text Control
uncheck merge cells

HTH

--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis





"Mark" wrote:

Somehow I ended up eith sets of merged cells down "O" column. They start at
O22 and go all the way to O851. There is text involved above each 4 cell area.

Ie ;
O20 has text(Est. Date)
O21 is blank
O22 is merged with O23 and reads O22 when selected.

Above this I am fine but the 200 sets of these below have the bottom 2 of
each group of 4 merged.

I can't figure out to unmerge these particular cells. I just want them all
back to normal.

I tried selecting the column, cell,alignment but the merged box is not
checked. I'd hate to do these one at a time.

Is there help?

Thanks Mark