Is there a shortcut key to merge cells in excel.

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.

P Anthony wrote:

Is there a shortcut key to merge cells in excel.

--

Dave Peterson

You can also give the appearance of merged cells by:

1.highlighting the desired number of cells
2.FormatCellsHorizontalCenter Across Selection

I was told that that will avoid possible problems.

--
smither fan


"P Anthony" wrote:

Is there a shortcut key to merge cells in excel.