What is the Keyboard Shortcut of Merge and Centre Tool Command

Pls tell me shortcut key of Merge and Centre Tool Command.

Rao Ratan Singh, India

To my knowledge, they do not exist, however, you can record two separate
macros, assign to keystroke for each feature and then you have your own
hot-keys.


--
nbrcrunch

in a tortuous way one can think of series of keyboard actions

alt+o
e
a
alt+m
enter

not a single short cut.
mine excel 2000
==================
nbrcrunch <[email protected]> wrote in message
news:[email protected]...
>
> To my knowledge, they do not exist, however, you can record two separate
> macros, assign to keystroke for each feature and then you have your own
> hot-keys.
>
>
> --
> nbrcrunch

Hi!

Unfortunately Excel 2003 doesn't show shortcut keys in the ScreenTips for any of its buttons. (Why? It's so useful as a learning aid). So I've not been able to find the shortccut (if it exists).
However, it has a single toolbar button which does merge/centre. You can produce your own shortcut key by recording as a macro the result of clicking this button.

Alf

True, but as you note, it is laborious. The user may as well just click
the icon on the format bar-that would be quicker.

Before posting the message, I tried to the following:
1. Set the macro to record and assigned Ctrl-Shift-A
2. Selected two cells
3. Clicked the merge icon
4. Stopped the recorder
5. Edited the code to remove the 1st line (the reference to he
selection)
6. Saved the macro

After testing it worked fine on ANY selected group of cells.

In retrospect, I could have started the recorder AFTER the cell
selection so that steps 5 & 6 would have been eliminated.


R.VENKATARAMAN Wrote:
> in a tortuous way one can think of series of keyboard actions
>
> alt+o
> e
> a
> alt+m
> enter
>
> not a single short cut.
> mine excel 2000
> ==================
> nbrcrunch [email protected] wrote in message
> news:[email protected]
>
> To my knowledge, they do not exist, however, you can record two
> separate
> macros, assign to keystroke for each feature and then you have your
> own
> hot-keys.
>
>
> --
> nbrcrunch-


--
nbrcrunch