Cannot merge cells, old spreadsheets, new Excel

[user]

Using Excel2002, having upgraded from Excel'97.

Whenever I open up an old spreadsheet, the "merge cells" command is
not accessible. It it grayed out on the toolbar, and if I try to
manually format a cell/cells, "merge cells" is checked and grayed out
for every cell in the worksheet.

 

[Gord Dibben]

user

Perhaps the sheet is protected under Tools>Protection?

If not, try this........

CRTL + A to select all cells on the sheet.

Format>Cells>Alignment. Click on the grayed-out Merge check-box a couple of
times to set and re-set to clear it.

Gord Dibben XL2002