Grab the file with all shortcuts from here 👉 pages.xelplus.com/excel-shortcuts-file

Thank you for sharing concise and quality tutorials with us. For Pivot table ctrl + A to select the data set Alt + N+V for pivot table

Awesome lecture! It would be really helpful for the ppl working in actual field.

Hi Leila, Thanks a ton for your useful videos! The most common Excel short cut key I use is Ctrl+D. If I am in a particular cell it just copies the value of the corresponding column cell in the row above it. It applies to formulae too. I use this along with Ctrl+Space to copy formulae for all cells of the row above current row..

Amazing one..The flash fill is interesting. One from my side is alt+o+c+a. This would auto align the cell size based on its contents size.

Thanks for the video. I would like to add 3 more to the list Ctrl + D/R - Copy the value/formula to adjacent cells down/right Ctrl page up/down - for navigating through sheets F2 - will let you edit the formula from the cell itself

My two favorite shortcuts I've learned in the past few years are: cntrl [ in a cell with a formula linked to another cell (could be a cell on a different tab or file) and it will take you directly to it. Then to get back the shortcut is F5 Enter. These are my favorite shortcuts and I never see these on shortcut lists. Great video overall as usual!

Thank you so much. Leila. Excellent presentation skills and delivered at a good pace. I train professionals for a living and it was great to see content set out, both logically and without any unnecessary waffle. A life saver !as I needed to check-in with my 'sleepy' Excel skills . Will be following your other videos.

@Leila Gharani You've taught me the fundamentals of MS Office much better than anyone else. I'm constantly working with all these platforms, but hardly knew the tricks to use it efficiently. Thanks a million 🙏🙏🙏

Thank you very much for all the short cut tricks. You are awesome!

Very informative indeed!!.. Probably the most needy part of Excel has been covered here to be a master of key strokes. Sharing 2 shortcuts i use alternately to insert row & columns. Add Row - Alt + I + R Add Column - Alt + I + C Keep shining..👏👏

I've just found you today, while I was seeking for some help for my Excel for work and I am obsessed with your videos. You are so incredible! Thank you so much for everything you show us!

Holding shift so that you can drop a row or column between two rows or columns... I have needed to know this for so long! Thank you!

Great tips, thanks. An additional, the recently added right-click menu shortcut on keyboards is very useful in Excel. Alt+E+S+V is like right-click (keyboard) then V.

To paste as values, u can use "ctrl + Alt + V"

This woman is God-given.

Thank you! I shared your video with my team this morning and it was well received.

I wish I'd found this years ago! Love from Brazil.

This is a very informative video, I highly recommend it. Most of the short cut keys work . But some shortcut keys of my excel are different. For example, in my excel, the shortcut key of the autosum is "Command+Shift+T". You may need to check your shortcut key or customize one in your excel under "Tools"→"Customize Keyboard".

Brilliant! This is so handy! Thank you

Excellent! Great help!

Super!!! Good tutorial to watch even after so many years of experience in excel. Thank You. Cntrl + D or Cntrl + R are also useful shortcuts for quick copy downwards or to the right.

This is the best excel training I found in my life. Microsoft should hire you

Now this was very helpful. Thanks

thank you very much!! these are really helpful

*All these short cuts I knew already but you explain it perfectly*

This channel is so underrated !

Wow! Highlight constant is something which I was not aware at all! thank you so much!!!

Very useful, thanks.

Some great shortcuts, and I didn't know the one for highlighting the numerical constants at the end. I shall practice that one! One of my favourites is an alternative to yours for Copy and Paste Values. The Ctrl key on its own opens Smart Tags, so what I do is this: Select, then copy with Ctrl C Paste as normal with Ctrl V, but then tap and release Ctrl, then V. This opens the Smart Tag and selects the Values option. Other letters select other options in the Smart Tag box, e.g. Ctrl then A gives you Values and number formatting.

Alt+D+F+S for clearing the filter from all the rows without actually removing the filter. Ctrl+shift+L will remove the entire filter, while Alt+D+F+S just clears it Alt+O+C+A for auto width column Alt+H+N+S for converting number to Short Date Alt+H+K for converting the number into accounting format. Been using these options frequently. Thank you Leila for the valuable inputs.

Your voice is so clear and beautiful, Leila!! Greetings from Brazil!!

So glad I found this channel!

Ctrl+Shift+End highlights to the last data element in a sheet. I like this one because it does not stop at cells that are blank but have data below and to the right that are not captured by Ctrl+Shift+down arrow and Ctrl+Shift+right arrow.

Thank you for number 16. Here's a few of my own (haven't checked to see if they are mentioned already). ctrl + Home - takes you to the top left of a data set ctrl + end - takes you to the bottom right of a data set ctrl + Page Up - switches tabs to the left ctrl + Page Down - switches tabs to the right

Awesome Professional/Professor! Congrats, Leila!

Great video Leila! 2 usefull ones :) Select only visible cells from a selection: Alt + ; (semicolon) Drop down list without duplicates without validation nor asigning name : Alt + down arrow (cells on the same column, works with tables o raw data range) PD: Paste Special box short shortcut: Alt Gr + V

Awesome lecture as always! I prefer Alt, H, V, V instead of Alt, E, S, V (you gotta press enter or click ok after that cause it's a button choice). I guess it's stuck in my brain from months of usage, even though ES is shorter than HVS when you need a special not on the main menu, but I can't get myself to use it. So I use HVV for paste values (you can do HVSV enter or ESV enter), HVW column widths (you can do HVSW enter or ESW enter), HVF formulas (you can do HVSF enter or ESF enter), HVR formats (you can do HVST enter or EST enter). To be completely honest I am trying to incorporate HVF and HVR instead of HVSF enter and HVST enter but like I said it's not leaving my head. Hope I've helped somebody. Also absolutely love Shift+Ctrl+L for filters, Ctrl+E flash fill magic and Shift+Space/Control+Space for the selection (didn't know those last 3, ty!). For insert row I use Alt, I, R, or Alt, I, C for columns. But yours is just fine, in fact it's better since there's no equivalent for deleting them in my solution. Gonna have to learn those! Also I love F4 in all of its uses. The bonus just blew my mind...

at 2:55, you can also use Ctrl + Alt + V(which opens the paste special menu), and then press V to paste special as Values. shortly Ctrl + Alt + V + V

Thanks a lot. Very informative. Useful tips.

Thanks for sharing! 👏🏻👏🏻

Thank-you for the shortcut tips. Possibly faster way to insert a column or row is : Select a cell, press Alt+IC to insert a column to the left, or press Alt + IR to insert a row above. Easy to remember because IC is short for Insert Column, IR is short for Insert Row.

F4 to repeat last action F4 in formula to change relative/absolute reference

Thanks Leila for this great video.

Thank you vert much for sharing concise

You're my best teacher in excel

Hi Leila.. great summary of useful keyboard shortcuts. You might want to add.. to unhide hidden rows CTRL+SHIFT+9 and unhide hidden columns CTRL+SHIFT+0. Also, if you want to group instead of hide, use SHIFT+ALT+RIGHT ARROW (to group) and LEFT ARROW (to ungroup). Another good keyboard is ALT+Q to jump to the Tell Me or Search field to quickly query EXCEL for help. I use these every day. Thanks for sharing and thumbs up!

I really enjoy your videos.....Excel is something with infinite possibilities.... My fav and an addition to the 1st tip (Ctlr + Shift + L) is related to a table with filters: Use "Alt + down arrow" at the filter location. This enables / opens up the drop down menu where one can select whichever they want. Hope this helps. :)

Thanks, Leila it was really great learning.

To paste as values, I like to use the short cut Alt+H+V+V Easier to remember and quicker to insert

Ctrl + k to create a hyperlink Ctrl + u to expand the formula bar

Loved this

Very useful, many thanks

Highlight a dataset and press Ctrl + . This is go through all the four corner values of the data set turn by turn. This is especially important to check if the formula and references are correctly captured.

Some of my other favorites are Ctrl ~ = switches to a view to show formulas in text. Can toggle off and on Alt E S T, or Alt E S F (or for transpose, multiply, etc) Not specific to excel but the windows key + arrow keys is amazing with multiple or large monitors to move your windows around and split screen Shift F9 same as F9 but only on the current tab. Big help in large data files

thanks you so much leila its helpful for me well done nice job!!!

Thank for the tips.

Thanks. Ctrl+] and Ctrl+[ to find related cells.

Really useful. Just want to add one of mine, Ctr + ~ to show all the formulas in the sheet and same to hide.

Very simple content, very helpful and useful for people who are getting started with excel and would be using this application regularly.

Great tip, thanks

Ctrl+tilda, squiggly key below Escape key, shows the formulas behind the value. Great video by the way!

Her voice is awesome, i can improve my communication by listening to her

Very informative thanks

Thanks for knowledge.

The best shortcut I know.... Alt - A - C which clears all filters, without turning off the filter option from the table

I'm using "Alt W F F" for freezing columns and rows which is very useful for me

Thank you so much, really amazing tricks

Very Useful Thanks

*Ctrl +1* and *Ctrl+E* are awesome, Thanks Careful with the Autosum if there are any blank cells in the column or row.

cheatsheet of shortcuts from the comments (your welcome xo xo) Ctrl + home = top left cell Ctrl + end = lower right cell Ctrl + down button = selected column lower cell Ctrl + t = selected data converted to TABLE Ctrl + space bar = selects the entire column cells Ctrl + page down = switch to next sheet Ctrl+ page up = switch to previous sheet Ctrl + d = tap one the cell drag down to add that data press ctrl+d Ctrl + a = selects all Ctrl + v = paste Shift + space bar = selects the entire row Paste Special box shortcut Ctrl+Alt+V Ctrl+[ to go to the linked cell & F5+enter to return back. Following is one short key that I use to select the required columns at one instance to past in different sheet, for example random 5 from 30 columns/rows Select column then Shift -(minus) Then select another column then again Shift -U can use it n number of times as u wanted. ctrl+1 for opening the format Ctrl+0 for hiding column Ctrl+9 for hiding row The short key to move entire row or column data is Shift+Space then Ctrl+x Select the row to move Shift+Space then Ctrl + Same works for moving the column Ctrl+w to close an Excel file, but not the application F4 to repeat last action F4 in formula to change relative/absolute reference To paste as values, I like to use the short cut Alt+H+V+V Ctrl+] and Ctrl+[ to find related cells. Alt W F F" for freezing columns and rows which is very useful for me Ctrl + alt + v is another shortcut for paste special Alt+ H + O+ I. Auto fits cells/rows/columns to their contents Clear Filter (NOT Remove) = ALT + A + C Unhide Row: CTRL + SHIFT + 9 Unhide Column: ALT + O + C + U Ctrl + k to create a hyperlink Alt Pg dn - move column wise right Alt Pg up - move column wise left Ctrl + u to expand the formula bar ctrl+pageup change sheets ctrl+pagedown shift+f2 comments alt+f11 vba Alt+E+S+V Always Extract Some Values F12 to bring up save as F2 - edit formula directly in the cell lt E L to delete sheet & Alt E M to move/copy sheet. Ctrl + D/R - Copy the value/formula to adjacent cells down/right CTRL + ~ to expose formulas CTRL + ~ to change it back. Alt+w+h hide work book short cut for inserting rows & columns. Alt + I +R for rows Alt + I +C for columns first select the no. of rows (e.g. 2) then use shortcut to insert the selected no. of new rows. Same is for coloumns. Possibly faster way to insert a column or row is : Select a cell, press Alt+IC to insert a column to the left, or press Alt + IR to insert a row above. Easy to remember because IC is short for Insert Column, IR is short for Insert Row. Shift+Del then enter an alternate to cut n paste

wow thanks Leila Gharani!!!!!!!!!it was very useful

You are the best excel guru on the entire Internet, love your videos and the knowledge you share! Thank you!

Shift+cmd+v - when you want to past only formatting, without affecting values in the destination cell. for special pasting - I use always contol+cmd+v and then select what i need to paste

wow. nearly every one of those was a revelation! and I've considered myself a pretty solid Excel user....for the past 30 years!

Thanks for all these tips. Great Tutorials

Excellent tips. 👍

F5 Alt+S,O,X really blew my socks off!!!

That's a flash fill MAGIC!

Thanks. This Video was Elegant.

Very helpful..Thanks.

Alt+M,D to quickly trace dependents (nice in combination with Ctrl+[ and F5 mentioned below). Ctrl+tilde to toggle formula view on or off. Shift+F10 for a context-sensitive right-click, opening up lots of possibilities with context menus.

we should know leila is a Queen of Excle thanks for every things

Smart and beautiful. Thx for these shortcuts

This video was amazing!!! Thanks a world

Good & Very helpful short cuts. There is one more short cut for inserting rows & columns. Alt + I +R for rows Alt + I +C for columns first select the no. of rows (e.g. 2) then use shortcut to insert the selected no. of new rows. Same is for coloumns.

Ctrl-D to fill down, F2 to edit active cell, and F12 to save as... are among my most used shortcuts not mentioned in this video. Personally I find the old versions far superior for the ease of discovering keyboard shortcuts. The loathsome ribbon interface in 2007 onward hides the handy Alt key menus (unless you had already memorized them from running older versions, which is why the dropdown menus were already better in the first place.) Excel 5.0 inside of Office 4.3 also allows you to revert the menus to the Excel 4.0 format and back, which makes some repetitive keyboard shortcuts even faster.

thank you, this was really good

Great job!

Following is one short key that I use to select the required columns at one instance to past in different sheet, for example random 5 from 30 columns/rows Select column then Shift -(minus) Then select another column then again Shift - U can use it n number of times as u wanted.

amazing. thanks for sharing

I have learned ctrl+1 for opening the format Ctrl+0 for hiding column Ctrl+9 for hiding row The short key to move entire row or column data is Shift+Space then Ctrl+x Select the row to move Shift+Space then Ctrl + Same works for moving the column Thank for the lesson

Clear Filter (NOT Remove) = ALT + A + C Unhide Row: CTRL + SHIFT + 9 Unhide Column: ALT + O + C + U

Excellent! Tks

I just came across this video. Great as usual. Thank you so much!

Ma’am, you just saved my professional life. Thank you very much!

Alt+i+c for adding column, Alt+i+r for adding row, Alt+i+w for adding new sheet, Ctrl+k for hyperlink, Alt+d+l for data validation, Alt+n+v for pivot table, Alt+i+o for inserting any object, Alt+h+o+r for renaming sheet, Alt+o+a for auto formatting, etc.

I wanna say you're the best, These tips really helps a lot!!! :)

Useful tips, thanks a lot Leila, need to add a tip (if not mentioned somewhere before) : to drag cell(s) from one sheet to another one : highlight the cell(s) press "ALT" key then drag from the cell(s) edge to any other sheet in the same workbook.

Just wondering why someone will thumb down on an awesome video like this.