Excel Keyboard Shortcuts used by Pros - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Emil
Yay, love shortcuts - the Alt + -=- and Ctrl + (Shift) + -;- are new to me. The others I use all the time, but great refresher nevertheless. I use also Ctrl + 2-3-4-5 for bold/italic/under/strike formatting and Ctrl+Shift+1-2-3-4-5-6 for number formatting. Also Ctrl + (Shift) + 9-0 are handy for hiding / showing rows and columns. Occasionially use Ctrl + 8
reply
Yay, love shortcuts - the Alt + -=- and Ctrl + (Shift) + -;- are new to me. The others I use all the time, but great refresher nevertheless. I use also Ctrl + 2-3-4-5 for bold/italic/under/strike formatting and Ctrl+Shift+1-2-3-4-5-6 for number formatting. Also Ctrl + (Shift) + 9-0 are handy for hiding / showing rows and columns. Occasionially use Ctrl + 8
reply
Maxim
I also use:
Alt+; to select only visible cells
Ctrl+[ to select direct precedents. Then press F5 (or Ctrl+g) and Enter to go back
F9 evaluate part of a formula
Alt + DS for Sort-
Ctrl+_ (Ctrl+Shift+---) to clear all borders
Ctrl+Shift+- to apply general formating
reply
I also use:
Alt+; to select only visible cells
Ctrl+[ to select direct precedents. Then press F5 (or Ctrl+g) and Enter to go back
F9 evaluate part of a formula
Alt + DS for Sort-
Ctrl+_ (Ctrl+Shift+---) to clear all borders
Ctrl+Shift+- to apply general formating
reply
Dillan
Not sure if you-ve identified this as this video was put on some time ago, I found by mistake that if you hold the key with the symbol of a square with 3 lines in it (Right hand side of the keyboard next to CTRL) plus the -V- key then this is also PASTE VALUES -
reply
Not sure if you-ve identified this as this video was put on some time ago, I found by mistake that if you hold the key with the symbol of a square with 3 lines in it (Right hand side of the keyboard next to CTRL) plus the -V- key then this is also PASTE VALUES -
reply
irshad
I just wanted to add there are many Alt key shortcuts that were available in excel 2003 still works in latest version one of that you already mentioned Alt ESV for value paste likewise Alt ORE row hight Alt OCW adjust column width Alt OHR sheet rename etc etc..
reply
I just wanted to add there are many Alt key shortcuts that were available in excel 2003 still works in latest version one of that you already mentioned Alt ESV for value paste likewise Alt ORE row hight Alt OCW adjust column width Alt OHR sheet rename etc etc..
reply
therealrochrocks
If your clipboard is in the ribbon then to Paste Special Values you can also use [Alt] - H - V - V.
Alternatively if your keyboard has a -right-click- key then the easiest way to paste values is -right-click- key - V
reply
If your clipboard is in the ribbon then to Paste Special Values you can also use [Alt] - H - V - V.
Alternatively if your keyboard has a -right-click- key then the easiest way to paste values is -right-click- key - V
reply
Rob
These are all the old shortcuts - why not cover the incredible power of the alt key generally? It gives you access to practically everything with notable exceptions - I'm looking at you -Center across selection-!
reply
These are all the old shortcuts - why not cover the incredible power of the alt key generally? It gives you access to practically everything with notable exceptions - I'm looking at you -Center across selection-!
reply
optizap
CTRL E for flash fill without having to drag the cross, CTRL enter to fill a set of non contiguous selected cells with a value or text - useful for filling blanks after finding them with Go to Special.
reply
CTRL E for flash fill without having to drag the cross, CTRL enter to fill a set of non contiguous selected cells with a value or text - useful for filling blanks after finding them with Go to Special.
reply
Paul
You should do a video on the quick access toolbar. I'm curious to see what you put up there. The first 9 spots are really valuable because their shortcuts are alt + 1 - 9 which are really convenient.
reply
You should do a video on the quick access toolbar. I'm curious to see what you put up there. The first 9 spots are really valuable because their shortcuts are alt + 1 - 9 which are really convenient.
reply
mrnoadable
TIP: Go back to typing basics and always start at the -home keys-. Teach yourself how to move to the [Control], [Alt], and Function keys without looking away from the screen.
reply
TIP: Go back to typing basics and always start at the -home keys-. Teach yourself how to move to the [Control], [Alt], and Function keys without looking away from the screen.
reply
----
Great video. BTW, the Menu/Application key is sometimes missing (e.g. laptops), but the Shift+F10 is always there, and do the same trick, and of course works in all Windows apps.
reply
Great video. BTW, the Menu/Application key is sometimes missing (e.g. laptops), but the Shift+F10 is always there, and do the same trick, and of course works in all Windows apps.
reply
Add a review, comment
Other channel videos
