Excel Shortcuts that Will Save You Hours of Work (Windows & Mac)

Excellent Myanda, to help us work more efficiently.

Been a windows user all along and gonna switch to Mac soon..
Do you think, it is hard and time taking to adapt to the Excel in Mac ??

👍👍👍👍 F12 - wow I didn't know that. The new save as is awful combined with OneDrive as only hard disk folders are offered and none of the quick access links I set up on Explorer are available. thankyou - Thankyou - THANKYOU
Control-a is vastly underused. Likewise ctrl-r/d which can also be used on a single cell to copy the cell from the left / above.
You undersell F4. It does not only do the ctrl-y job of un -un doing. It repeats an action as well.
So a formatting action can be done on one cell, then another cell or range and yet another with F4.

I use (and already knew) a lot of the tips you show in your video. But what I find a real time-saver as well sometimes is by using the QAT. I've put a lot of usefull commands in there e.g. Paste Values, Paste Formats, Clear Formats, Select visible cells, Paste formulas and many more. And easy to export those settings and import on another PC

Great video Ma'am
I've learnt new shortcuts

I love my control t with a cell selected in the range. And then it goes and just opens a new tab in Edge.

F4 repeats the last command for Word, Excel and PowerPoint
Ctrl+d also duplicates if you have an object selected

Nice to see my beloved Alt+W FF. Another favorite of mine is Alt+D FF.

I just came across your channel can't believe I am starting to understand Excel. Highly appreciated 🎉🎉🎉

So pretty and very smart.

I'm a subscriber and was sorry to hear about the security breach. You have educated the public how disruptive a breach can be to one's personal and professional life. Great to have you back.

F12 to save is a game changer!

Thank you For Your help..

Ctrl+Shift+L to add/remove a filter
Ctrl+; to add today's date
Windows+. to open smileys 👍←↑→↓△
Alt+ letter (quick access keys) for example Alt+E then G correspond to Ctrl+Alt+V
Ctrl+Return to apply formula bar change to all selected cells
Shift+ ←↑→↓ to add/remove rows/columns to a selection

Excellent, thanks Mynda. Very helpful especially for people still learning Excel.

Simply the best. Very useful video for me as I use mac. Thank you.

I love shortcut keys it cuts down on the need to move your hand from the keyboard to the mouse also, unfortunately, I am old enough to remember using computers before the mouse was a standard feature, I still find myself going for the old alt key codes to get to the menus or rather ribbon these days!

Ctrl+Shift+mouse wheel is amazing . Thank you.

I use ALT+number to quick access

Not sure if it's worth mentioning but I believe it's not actually ctrl + 0 and 9 to hide but ctrl + '(' and ')'.

Most of your videos put me in the ball park of "I wish I knew sooner" 😛

I've been using personal computers since the late 70's, and used one of the first word processing programs WordStar. MANY of the shortcuts that were in WordStar have continued long past it being replaced, many of the shortcuts you noted!

Thank you, this is brilliant! Where were you 20 years ago?

How have I never known Ctrl+Alt+V???? Thank you!!

Thanks; that’s handy. I’ve familiarized myself with Alt key combinations with home ribbons (Letters).

CTRL+6 is hide shapes, graps, pictures.
CTRL+W close the current workbook
ALT+F4 close the excel
CRTL+* select the corner cells of current region.
SHFT+Space select the entire row
CTRL+Space select the entire column
CTRL+Page up shift the next sheet (CRTL+SHFT+3)
CRTL+Page down shift the previous sheet (CRTL+SHFT+9)
SHFT+F10 open the object pane
SHFT+F8 open the random selection
ALT+Down+Up Arrow Open the drop down list

It's great to see you back up and running. I need to convert ranges with formulas to values almost daily. I right-click on the selected range that has formulas and drag it to where I want it and then choose Copy Here as Values Only,