Excel Keyboard Shortcuts For Comments & More… (stuff on the Review tab)
This post covers six Comment-related shortcuts, plus five other shortcuts you can pull off with Alt-R sequences. That’s 11 shortcuts in all.
On Excel’s Review tab, you can manage Excel comments (creating, deleting, editing, showing and hiding) — AND and use the Thesaurus and Spellcheck function, plus features related to “Changes.”
If you use the Review tab a lot, read on for some quick shortcuts that allow you to avoid clicking on the Ribbon. Otherwise, explore more useful posts!
How do you use Review tab commands without your mouse?
Alt-R Brings Up The Review Tab
Just type Alt-R (Alt, then R), and then the correct shortcut key (or “keyboard accelerator”). (Read more about Excel’s Alt shortcuts).
Because R can be typed with your left hand, some of these shortcuts will allow you to leave your right hand on the mouse. Therefore, you can avoid the “speed penalty” of moving your right hand from the mouse, to the keyboard, and then back.
Once you’ve typed Alt-R, just type the letters below that you will see pop up on your screen. I’ve circled the left-handed ones in red. The first screenshot is when a comment cell is NOT selected; the second screenshot is when a comment cell IS selected.
Here are the ones I use most — they’re all Comments shortcuts:
|Show All Comments||Alt-R-A|
Alt-R-H requires your left finger to move into right-hand territory to type “H” — but only one inch.
Here are the remaining left-handed shortcuts (which I don’t use as often, but you might):
Alt Shortcuts Are Easy — No Memorization Required
Memorizing these (and all) shortcuts will make you faster than if you don’t memorize them.
But you really don’t have to memorize Alt shortcuts — since Excel shows you the shortcut key.
Just remember what tab things are on.
Comments, Spellcheck and the Thesaurus are all on the Review tab, so you type Alt-R to access them.
I hope these shortcuts make you a little faster at Excel!