Merge-Center icon

[Guest]

On some of my spreadsheets the "Merge-Center" icon is not active. The
simple spreadsheet instruction are of no help.

 

[Guest]

Is the sheet protected? If so, try Tools>Protection>Unprotect Sheet

 

[Guest]

Hagen, I believe you are on to something. As you wrote I followed your
discussion, but when I clicked on "protection" a dialogue box opened with the
top three items dim "Protect Sheet","Allow users to edit ranges","Protect
Workbook", and with "Protect Shared Workbook" darker print. When I clicked
on "protect Shared workbook" I got a dialogue box that was labeled "Protect
Shared Workbook"
with a selection box labeled "protect with track changes" all other options
were dim. Any suggestions form here?
Thank you
RoofinPA

 

[Gord Dibben]

If the workbook is shared, Merge will not work and be grayed out.

Unshare the workbook.

Gord Dibben Excel MVP