Is the workbook shared?

If so, unshare and your merge will come alive.


Gord Dibben MS Excel MVP

On Sat, 19 Sep 2009 12:14:01 -0700, CWHelp
wrote:

I inherited several spreadsheets and the merge cell icon is shaded and will
not allow operation. Also, cannot check or uncheck box in format cell.
I have removed sort function but not luck. The sheet is not protected? Does
anyone any idea how to reactivate the merge function?