Shortcut key - merge cells

[Guest]

Is there a shortcut key to merge cells in excel.

 

[Dave Peterson]

There's an icon on the formatting toolbar (xl2003, at least).

But no single shortcut key to do this.

ps. You may find that your worksheet looks prettier with the merged cells, but
there are lots of things that fail with merged cells (sorting, copy|pasting,
....).

You may regret it if you use merged cells.

 

[Guest]

You can also give the appearance of merged cells by:

1.highlighting the desired number of cells
2.Format>Cells>Horizontal>Center Across Selection

I was told that that will avoid possible problems.