However, you'll like the following tip it gives:
"If an action you use often does not have a shortcut key, you can record a macro to create one."
Hope this helps.
I use Excel everyday at work, & I prefer to use shortcut keys & hotkeys rather than the mouse, e.g. ctrl + C,V,X or A, alt + tab, winkey + M or L to name a few of the many I employ. Here's something I can't work out:
How do you align the contents of a cell using shortcut keys or hotkeys?
Perhaps there are different combinations or shortcuts for the three alignments, left, right & center, or perhaps there is a single shortcut which you can use and on continuous pressing it will cycle through the alignments.
I realise that this may not actually be possible, but if it is, please help me, I hate having to use the mouse to select one of those buttons.
ok. There is another faster way but still through the cell alignment box. There should bea key at the bottom of your keyboard between to the righthand Ctrl and the windows key hit that key when your in the cell you want aligned and then F and the format box will pop up then you tab and use your arrow keys to select your option.
Not exactly the answer you're looking for I'm afraid (i.e. aren't hotkeys as such) but worth bearing in mind maybe, if the entries you're adjusting are text-only values.
During text value entry into a cell, begin your entry with one of the following characters to force horizontal cell alignment:
' (apostrophe mark) - Left Align
^ (caret/circumflex) - Centre Align
" (quotation/speech mark) - Right Align
You use Alt/V or Alt/H. This takes you to the toolbar. Use your arrow keys to go to Format. Cell alignment should be the top one. If not, tab down within Format to get to cell alignment Hit Enter. Use arrow keys to go to Alignment tab. Tab down to Horizontal or Vertical. Arrow to go left/right/center ect. Hit enter. Tab again to align the other one. Hit enter and your aligned. Good luck. Let me know if this worked for you.
I still prefer the way Microsoft advised: record a macro (and keep it in personal.xls, your personal macro file). Then, for example, ctrl-shift-R = right align, and same for ctrl-shift-C or ctrl-shift-L. Or use any other shortcut that's free or you don't use and is easy to remember for you.
Recording a macro is fast and easy. No need to know how to program, just point and click and do.
If you do not want to use mouse for aligning cells in excel, do not use mouse. You can align cell in excel with the help of keyboard only. But, for that just press Alt key and then press Ctrl + Tab keys to move among toolbars. Select formating toolbar using this method. Select cell alignment button with the help of arrow keys.
Vishnu H. Thakor
Sublime suburban chariot
High on style and technology, the 2019 Volvo XC90 is an incredibly satisfying everyday crossover.