What is the Keyboard Shortcut of Merge and Centre Tool Command

R

Rao Ratan Singh

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

Rao Ratan Singh, India
 
N

nbrcrunch

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.
 
N

nbrcrunch

True, but as you note, it is laborious. The user may as well just clic
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 h
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 cel
selection so that steps 5 & 6 would have been eliminated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top