Merge Cell Button Greyed Out

[craig-o]

Hello all.

Someone has been futzing with my spreadsheet and has managed to break
it. I've got 6 cells (3 cells in 2 rows) I want to merge. They were
merged once, but as I say, someone has been playing. Anyway, I'm
trying to merge these 6 cells in a worksheet and the merge cell button
is greyed out. I can merge other cells in the sheet, but none of these
6 in any combination.

Any ideas as to how I can get these cells to merge, or un-do whatever
has been done that is preventing this, would be apprecaited.

Thanks all!

 

[Dave Peterson]

How about going through the menus?

Select your range
format|cells|Alignment tab|check the merged box.

If that doesn't work, try starting a new workbook and seeing if it works there
(both the menu and the button). It might help others if they know what else
works/fails.