is there a keyboard shortcut for "Merge" function in excel?

Not really.

But there are lots of merge icons that you could drag to your favorite toolbar.

Tools|customize|commands tab|format category
Merge Across
can get do each row (separately) in your selection.

There's an unmerge, too.


chrislamm wrote:

is there a keyboard shortcut for "Merge" function in excel?

--

Dave Peterson

Ctrl + 1 will get you to the format cells window but I don't know of a
keyboard shortcut for merge. However, in Excel 2000 (don't know about other
versions)there's button on the formatting toolbar to 'merge and center' (it
is to the right of the 'align text' buttons). Simply highlight the cells and
click.

"chrislamm" wrote:

is there a keyboard shortcut for "Merge" function in excel?

Many thanks!

"rmellison" wrote:

Ctrl + 1 will get you to the format cells window but I don't know of a
keyboard shortcut for merge. However, in Excel 2000 (don't know about other
versions)there's button on the formatting toolbar to 'merge and center' (it
is to the right of the 'align text' buttons). Simply highlight the cells and
click.

"chrislamm" wrote:

is there a keyboard shortcut for "Merge" function in excel?

Many thanks.

"Dave Peterson" wrote:

Not really.

But there are lots of merge icons that you could drag to your favorite toolbar.

Tools|customize|commands tab|format category
Merge Across
can get do each row (separately) in your selection.

There's an unmerge, too.


chrislamm wrote:

is there a keyboard shortcut for "Merge" function in excel?

--

Dave Peterson