Have you tried the following place to uncheck the merge cells?
First select only merged cells (this is important)
Go to: Format, cell, Alignment tab under "text control" untick the "Merge
cells"
--
R. Khoshravan
Please click "Yes" if it is helpful.


"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