Creating a keyboard shortcut

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to create a keyboard shortcut for alignment options such as:
left align, right align, etc?

Thanks.
 
Yes, record a macro (Tools > Macros > Record New Macro), do what you want to
do, when you're done click 'Stop Recording' -
Now go Tools > Macros and select the macro you've just recorded (it will be
Macro1, but you can alter this if you want to), go 'Options' and select the
keyboard shortcut you want.
Note that recording a macro will record all what you want it to do, PLUS any
your mistakes you might make. Its good fun though when you get it right!
Regards,
 
You must log in or register to reply here.

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

Similar Threads

Shortcut key for aligning data in cell 3
alignment in a validation list 3
Are there shortcut keys in Excel for Cell Alignment? 6
What is short-Cut forleft align and Right align? 1
Keyboard shortcuts (Lalit Sharma) 2
Is there a preferred protocol for alignment of numbers in a colum 3
Shortcut key - alignment 1
Align 2

Back
Top