"75gator" wrote
... How do I determine what has been merged
and then unmerge it?

Think the easiest way is to get rid of all the merge cells in the sheet. If
this is not a problem (the "total removal of all merge cells" part), then
you could try this on a spare copy:

Press CTRL + A to select entire sheet
Click Format Cells Alignment tab
Click to *clear* the "Merge cells" checkbox
(may have to click a few times)
Click OK

And .. guess you could also try reinstating the merge via an entire sheet
copy paste special formats (copy from your original sheet, paste the
format into the spare sheet)

But think it's better not to use merge cells ..
If you need to "center" col headers, try instead:
Format Cells Alignment tab
Under Text alignment:
select "Centre Across Selection" OK

You'd get the same visual effect
(w/o the "downstream" pains associated with merged cells)

To find merged cells wherever they may be, try this previous post by Dave
Peterson in .misc: http://tinyurl.com/83emz
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--