Grab the file with all shortcuts from here 👉 pages.xelplus.com/excel-shortcuts-file
@shahidulhasansarker6 ай бұрын
summited but not get mail dear Leila
@diveshgawshinde86074 күн бұрын
I used Ctrl+; to add date and Ctrl+ shift+; to add time But when I use flash fill Ctrl+E in some rows it shows wrong date, how to solve this ?
@practicalbusinesstips55915 жыл бұрын
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!
@renebartodziej37655 жыл бұрын
try Ctrl ] to get back
@nomiims4 жыл бұрын
Thanks
@heisnod4 жыл бұрын
@@renebartodziej3765 it works only in one sheet
@kari80704 жыл бұрын
Really great
@Tomm9y2 жыл бұрын
I found Ctrl [ about 10 years ago, the whole team worked in linked spreadsheets so everyone was thrilled to learn it too.
@spacemafia693 жыл бұрын
This woman is God-given.
@sumedhdandekar86043 жыл бұрын
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.
@dushyant_luckmakesurlife2 жыл бұрын
awesome.......
@tom_something3 жыл бұрын
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!
@AjayAnandXLnCAD5 жыл бұрын
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
@LeilaGharani5 жыл бұрын
Love these! Thanks for sharing Ajay.
@AjayAnandXLnCAD5 жыл бұрын
@@LeilaGharani pleasure is all mine
@rajuar19555 жыл бұрын
Ctrl shift 8 to highlights all the data
@hrleif89942 жыл бұрын
Ctrl page up/down - for navigating through sheets Yes, use this all the time
@user-ln4jj6hd8s6 ай бұрын
awesome Ajay. I like the navigating between sheets in excel, sweetness.
@VarunBanala2 жыл бұрын
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
@Haobey3 жыл бұрын
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
@relaxationlight66263 жыл бұрын
find it here kzbin.info/www/bejne/e4e5foKdqNR9eKM
@chetswaman5 жыл бұрын
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
@Raj2erum5 жыл бұрын
To paste as values, u can use "ctrl + Alt + V"
@joem1125 жыл бұрын
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.
@LeilaGharani5 жыл бұрын
Love Alt IC and IR. You're right - very easy to remember!
@nomiims4 жыл бұрын
thanks
@itsmesarvesh2 жыл бұрын
It's Really Awesome & Fantastic
@oneoneday2 жыл бұрын
Incredible nice one
@crice745 жыл бұрын
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.
@slamatali28922 жыл бұрын
Just Wow.
@chaddemeuse37982 жыл бұрын
Thanks Charles!
@vishalgala10795 жыл бұрын
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.
@BasuYadwad3 жыл бұрын
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..
@martapunsola20252 жыл бұрын
This is the best excel training I found in my life. Microsoft should hire you
@emmalungulesei9418 Жыл бұрын
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!
@stephanddd8 күн бұрын
Thanks for the great comments. I use "Alt ;" all the time to copy visible cells only (instead of using the "select special" menu). You highlight the area you want to copy first, then type "Alt ;", and then Ctrl-C to copy... now you can go paste this anywhere with Ctrl-V (or right-click paste), and you'll only be pasting the visible cell you copied.
@erinkirby26493 жыл бұрын
I have been called the Queen of Excel or the Excel God so many times when I have a colleague see me use Excel. I consider myself a pro. I've been teaching my spouse Excel for the last few days, and pulled up these videos to help him learn more. I learned a new shortcut from the video, and a few from the comments, too!! Thanks so much!! You're amazing!!
@VN-ux2ep3 жыл бұрын
If you didn’t already know these shortcuts, then you probably are a beginner in Microsoft Excel and you’re surrounded by idiots!🤨🤨🤨🤨
@andywdrums3 жыл бұрын
The best shortcut I know.... Alt - A - C which clears all filters, without turning off the filter option from the table
@andywdrums2 жыл бұрын
@Ali T a shortcut is defined as an alternative route to get from A to B, that is shorter than the one usually taken
@andywdrums2 жыл бұрын
@Ali T 😂 because Ctrl + O is not a combination of keys? Sorry to have wasted your time, bro 😎 I bow to your far superior intellect 😂
@andywdrums2 жыл бұрын
@Ali T and to you, my friend… and to you
@realeyesrealisereallies97 Жыл бұрын
@@andywdrums gave a good chuckle there mate 😂
@chakrapani2012 Жыл бұрын
Hey, what ever the name it is, it works for me. Thanks.😊
@subhasispatnaik9755 жыл бұрын
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..👏👏
@raheelaarshad76694 жыл бұрын
I am happy to be the part of this group.I am just a beginner but after watching your tutorials and reading comments it saved and helped me at work.keep up the Excellent work.
@LeilaGharani4 жыл бұрын
Welcome aboard!
@nikhilverma10445 жыл бұрын
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.
@LeilaGharani5 жыл бұрын
These are great! Thank you for sharing.
@joemjoza98035 жыл бұрын
nikhil verma thanks for sharing. I have been looking to new sheet shortcut for a while
@varunkhadke84675 жыл бұрын
Great! Thanks for sharing👍👍
@gnbyrne4 жыл бұрын
These are great!
@alonsohernandez97793 жыл бұрын
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
@adriananunez7536 Жыл бұрын
Ohh!! Thanks a lot!!
@omnieraiq3 ай бұрын
Good
@MrSubasish3 жыл бұрын
This channel is so underrated !
@MohammadJNematollahi5 жыл бұрын
I'm using "Alt W F F" for freezing columns and rows which is very useful for me
@Silver-Clouds4 жыл бұрын
Very useful alt w f f
@mk678904 жыл бұрын
I use Alt DFF
@Juankestain5 жыл бұрын
F4 to repeat last action F4 in formula to change relative/absolute reference
@crice745 жыл бұрын
F4 is my favorite.
@bharatjha7623 жыл бұрын
Repetition command in word F4 Alt enter Control Y
@friendsanfriends125 жыл бұрын
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.
@cl8wnm5n3 жыл бұрын
Uppercase I or lower case l?
@566johncena2 жыл бұрын
@@cl8wnm5n it doesn’t matter
@kobostinywings2 жыл бұрын
Glad you posted this, these are the ones I use 😀
@adityasharma01014 жыл бұрын
To paste as values, I like to use the short cut Alt+H+V+V Easier to remember and quicker to insert
@jayaramb23433 жыл бұрын
I too like this shortcut Because excel automatically shows up this shortcut by pressing alt key. Alt+H->home Alt+H+V->paste Alt+H+V+V-> paste as values
@clairejsquibb5 жыл бұрын
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.
@rishabhmehta33645 жыл бұрын
Ctrl + k to create a hyperlink Ctrl + u to expand the formula bar
@lgvdbroek2 жыл бұрын
Ctrl+Shift+U to expand the formulebar
@rishabhmehta33645 жыл бұрын
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.
@djstone55183 жыл бұрын
Use this all the time. Love this for large ranges. Very fast way to verify the correct selected range.
@k.saikumarreddy3575 жыл бұрын
Her voice is awesome, i can improve my communication by listening to her
@tongnansekh89293 жыл бұрын
Cringe
@TheMaxKids3 жыл бұрын
Thirst...
@imranmohammed26445 жыл бұрын
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.
@dennissamual5 жыл бұрын
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
@wayneedmondson10655 жыл бұрын
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!
@LeilaGharani5 жыл бұрын
Love these! I plan to make a follow up to this and will add in the suggestions in the comments here. Thank you for sharing.
@wayneedmondson10655 жыл бұрын
Thanks.. a couple more I use: ALT+PAGE DOWN OR PAGE UP to move a full screen right or left; ALT+; to copy just the visible cells from a highlighted range that includes hidden or filtered rows or columns.. can also be used as a quick way to see if rows or columns are hidden via the thick double line that shows on the screen when selected; CLTL+C to copy and CTRL+ALT+V to bring up the Paste Special dialog.. then V, ENTER (or any other accelerator key for different paste special options) and ESC to complete the paste and deactivate the dancing ants. The list goes on.. CTRL+D and CTRL+R to copy contents directly above or directly to the left of the current cell; F5 or CTRL+G for the Go To dialog, etc... I love keyboard shortcuts and succession key sequences.. so much faster and more efficient than using the mouse, once learned and trained into the brain. Looking forward to your follow up. Thumbs up!
@heycarmiv2 жыл бұрын
Great tips thanks !
@kentturner92643 жыл бұрын
As a totally blind person using screen reading software, I have learned several hot key commands. That is how I learned to use the software. Thank you for this video and for adding a few I didn't know. You're doing a great job.
@LeilaGharani3 жыл бұрын
Thank you! I'm so glad it's helpful for you.
@Lykoskia5 жыл бұрын
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...
@LactatingPlatypus2 жыл бұрын
Another one for Alt, E, S, V is Ctrl (to bring up the quick paste menu), v (to select paste as values) for pasting values
@salala1822 жыл бұрын
menukey + v is also nice for pasting values, only if your right hand is free
@phvaguiar5 жыл бұрын
I wish I'd found this years ago! Love from Brazil.
@xlezpk4 жыл бұрын
Really useful. Just want to add one of mine, Ctr + ~ to show all the formulas in the sheet and same to hide.
@thomassentilhes71475 жыл бұрын
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
@LeilaGharani5 жыл бұрын
I'm glad you found something useful Thomas.
@abdrahman61725 жыл бұрын
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.
@derekeyler26342 жыл бұрын
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
@doncogleone6465 жыл бұрын
Ctrl+tilda, squiggly key below Escape key, shows the formulas behind the value. Great video by the way!
@BulkCarrierChiefMate5 жыл бұрын
F2 will do.
@sandeeppeddi70754 жыл бұрын
@@BulkCarrierChiefMate try it once and u can feel the difference
@msbeheavintoomuch59852 жыл бұрын
Presentations are so easy to follow.
@sharbhanu2 жыл бұрын
@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 🙏🙏🙏
@Excel_Mantra5 жыл бұрын
*All these short cuts I knew already but you explain it perfectly*
@lightning67185 жыл бұрын
Thank you very much for all the short cut tricks. You are awesome!
@michaelb17854 жыл бұрын
Very useful, thanks.
@hybriddude0072 жыл бұрын
You are the best excel guru on the entire Internet, love your videos and the knowledge you share! Thank you!
@georgeem89244 жыл бұрын
Clear Filter (NOT Remove) = ALT + A + C Unhide Row: CTRL + SHIFT + 9 Unhide Column: ALT + O + C + U
@EmpiricalPragmatist3 жыл бұрын
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.
@midoboy71222 жыл бұрын
One of the best channels on youtube for me , beg thanks Cntrl + D = fill down Cntrl + page up/down = Go to next/previous sheet
@saugata24 жыл бұрын
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. :)
@XAE_A_Xii5 жыл бұрын
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
@ShubhamSharma-ls6hj3 жыл бұрын
Which is cmd button on keyboard
@katewaller56952 жыл бұрын
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.
@Soulenergy315 жыл бұрын
Alt+N+V Pivot tables/ Ctrl+T Excel tables / Alt+D+F+F enable & disable filters / F4 absolute & relative reference / Ctrl+F1 hide and unhide Excel Ribon/ Ctrl+[ to go to the linked cell & F5+enter to return back. Beautiful video!!
@LeilaGharani5 жыл бұрын
Great! Thank you for sharing :)
@amanjajoo96624 жыл бұрын
Thank you so much.I am lucky to have you as a mentor
@LeilaGharani4 жыл бұрын
It's my pleasure
@DavidWonn4 жыл бұрын
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.
@TrilobitesRTasty3 жыл бұрын
Agreed on the ribbon mess. Microsoft started downhill when they decided users needed to see enormous images and banners and grey bars that take up a third of the screen. Removing and minimizing them is a temporary fix. Now, Teams is a nightmare of trash that forces the shared images to be less than half the screen.
@DavidWonn3 жыл бұрын
@@TrilobitesRTasty And it gets even worse for those of us with vision problems who need lower screen resolutions. The ribbon mess just takes up way too much of the screen at low resolutions.
@TrilobitesRTasty3 жыл бұрын
@@DavidWonn YES! I'm an old guy...and the so-called "Accessibility Settings" that Microsoft creates are unusable. So it is with monopoly power. They have dominance over the desktop, so no longer have to provide good products.
@DavidWonn3 жыл бұрын
Both of my retinae detached, so I prefer the zooming capabilities on my tablet over the accessibility features on newer PCs. One of the reasons is that over time, Microsoft gradually removed support for lower resolutions. This makes me gravitate to my ancient IBM PS/2, which allows me to run it in a sub-VGA resolution at 640*400 on Windows NT 3.51.
@TrilobitesRTasty3 жыл бұрын
@@DavidWonn Ouch. I have a history of retinal detachment in my family. For now, I just keep buying bigger monitors. At least the price of those is dropping (mostly).
@NOOBY93 жыл бұрын
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".
@rushitaroy302 жыл бұрын
I am just half way through the video and I realise this is so useful and that too for free :) thank you I m really grateful.
@LeilaGharani2 жыл бұрын
Glad it was helpful!
@AbhishekTripathidce4 жыл бұрын
I like to add more - Insert New Sheet - Shift + f11 Delete Sheet - Alt + H + D + S Open Name manager Dialogue Box - Ctrl + f3 Remove formatting - Select All Cell - Press - Alt + H + E + A One bonus which is very Important and frequently used option - Open Data Validation - Alt + D + L I hope this gonna work for All
@baba_agba3 жыл бұрын
Just wondering why someone will thumb down on an awesome video like this.
@truthseeker78333 жыл бұрын
Haters
@MrSnobby243 жыл бұрын
Dumb people and there is plenty of those
@cb95323 жыл бұрын
Because they are morons.
@Dulitzlives3 жыл бұрын
They are stupid
@bijubabloo53093 жыл бұрын
U can see some poops in some public place right These kind of people like that they cnnt appreciate something good And they cnnt do also something good
@karimal-mufakkir40414 жыл бұрын
Ma’am, you just saved my professional life. Thank you very much!
@LeilaGharani4 жыл бұрын
My pleasure Karim. Glad it's helpful.
@khamisame31353 жыл бұрын
I like your teaching
@khamisame31353 жыл бұрын
You have good technique and amazing for me
@MatteoTomaselli3 жыл бұрын
Hi Leila! Paste as values. Select a cell, put cursor to the boundary of the cell, right click and drag to destination cell, leave right button, select paste values. Following you in Skillshare!
@shahidansari-om8hk5 жыл бұрын
You're my best teacher in excel
@joep96175 жыл бұрын
*Ctrl +1* and *Ctrl+E* are awesome, Thanks Careful with the Autosum if there are any blank cells in the column or row.
@satyavijay49135 жыл бұрын
Not only blanks, if we have different any nunber in Bold will also be a block for auto sum. In case you have subtotals - auto sum helps us in totaling only sub totals :)
@djstone55183 жыл бұрын
@@satyavijay4913 Good points. Somewhat related though not a shortcut... Leila has a great video on =AGGREGATE() function and =SUBTOTAL(). I've been using the latter for years but just learned about the former, much more powerful function recently.
@dfsupport Жыл бұрын
Another awesome video! Shortcuts make my job so much easier!
@khawajaaamirali25365 жыл бұрын
Best online teacher, the way to teach is awesome.
@LeilaGharani5 жыл бұрын
Many thanks for the kind words!
@ekscaps64254 жыл бұрын
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.
@BOWENSblog3 жыл бұрын
Good to watch your random videos to expand my knowledge and also support a growth-mindset
@steffenfischer56692 жыл бұрын
Hi Leila, I have some new Excel Shortcuts for you! Shortcut Description [Ctrl] [Enter] Stay in the same cell after typing [Alt] [Shift] & From the input cell - selects all the formula cells that contain the output cell [Alt] [Shift] / From the formula cell - selects all the cells that are included in the formula [Alt] [Shift] $ From the formula cell - selects all the formulas cells that are included in the formula These are some Shortcuts that I find very useful in editing and checking my formulas!
@bschena5 жыл бұрын
wow. nearly every one of those was a revelation! and I've considered myself a pretty solid Excel user....for the past 30 years!
@LeilaGharani5 жыл бұрын
That's great. Now you have a few more things in your toolbox that will hopefully help going forward.
@Oppadu5 жыл бұрын
Awesome lecture! It would be really helpful for the ppl working in actual field.
@animecross97742 жыл бұрын
Thanx for the video it was very helpful there is one short cut for you, 1. Use Ctrl+R to copy in horizonal on the right side.
@mariarib6504 Жыл бұрын
I've been using excel since it was white letters on a black screen but the add features all the time but none of us have time to learn all about the software updates. The shift-drag to move a row between? Life changing for me.
@kvlpnd5 жыл бұрын
For paste as value: you can use ctrl C and then ctrl V and again Ctrl and after press V. My favourite and fastest.
@gt57135 жыл бұрын
Slightly faster if using macros, if you need to do this often: Put the below into your personal file, then assign the macro a shortcut of control-shift-V, or whatever shortcut you like. Sub PasteSpecialValues() 'shortcut ctrl-shift-V (paste values) Application.DisplayAlerts = False: On Error Resume Next: Selection.PasteSpecial Paste:=xlPasteValues: Application.DisplayAlerts = True: End Sub
@haerfrro14 жыл бұрын
Assign "Paste Value" to Quick Access Toolbar and then you only have to press Alt + 4 (or 5 or 6 or... depending on personalization). Only 2 buttons - it's the fastest...
@junelagbas15054 жыл бұрын
Easiest is ctrl C then you right click on the cell and press v
@jusjengkol5 жыл бұрын
That's a flash fill MAGIC!
@MrTr3D2 жыл бұрын
Awesome, learned great tips. Learning from KZbin sometimes is much better than taking a class
@akshayaeaswar55612 жыл бұрын
I’ve learnt more new ones from the comments section than the video itself! My additions would be: Alt + down arrow on a filter cell and alt+ space bar to select and unselect filtered texts
Wow! Highlight constant is something which I was not aware at all! thank you so much!!!
@mothiurNCL3 жыл бұрын
There's so much to learn, so useful, starting with saving so much time.
@vincentafnan-murray48504 жыл бұрын
Shift+F10+V is a shorter way to Paste Values. Shift+F10 brings up the right click menu. You can then also use this to paste formatting (+R) or formulas (+F)
@sethuca4129 Жыл бұрын
Ctrl+Alt+v directly opens the Paste special dialog box. You can then press V for values only, E to transpose the data, and so on
@user-eq7dk2lk2d5 жыл бұрын
we should know leila is a Queen of Excle thanks for every things
@herlenebrown23834 жыл бұрын
I am really enjoying these excel tips... They have been a very good source as a refresher courses for me! Thank you Leila
@sunilgagat28813 жыл бұрын
@@herlenebrown2383 please give regard call Leela mam👏👏👏
@pravinshingadia73374 жыл бұрын
Your videos are awesome. Been using Excel for several years but still learn things from you that I never knew and they make life easier. Thank you!
@LeilaGharani4 жыл бұрын
Glad to help!
@meerav76343 жыл бұрын
Very helpful. Have to write it down, so that we don't forget
@Phyrexian79ers5 жыл бұрын
F5 Alt+S,O,X really blew my socks off!!!
@RohitJain-dm1jk5 жыл бұрын
Paste Special box shortcut Ctrl+Alt+V
@TSSC5 жыл бұрын
Rohit Jain That is the shortcut that most colleagues ask me about: “How did you do that?!”
@JBB6855 жыл бұрын
Oh good, that one is fairly easy to remember too!
@VivekGupta19945 жыл бұрын
The best one is menu key + V
@petersaunders24135 жыл бұрын
I prefer Ctrl+V to paste and then ctrl followed by V to select paste values or Ctrl then M to paste unfromated text
@kifpowerbi5 жыл бұрын
Thank you Leila for the video, awesome. I Wana ask what is the tool you use to make your videos?
@rashidiqbal75472 жыл бұрын
i had not knowledge about Ctrl+space and shift+space thank you for valuable information
@jbkregs27664 жыл бұрын
I am really enjoying this channel. Your videos have been a great help.
@LeilaGharani4 жыл бұрын
I'm glad to hear that :)
@Jack.___5 жыл бұрын
Ctrl + * (the star/ multiply sign) selects all of the data - even if there are empty spaces or gaps
@frankrichardcaruso67192 жыл бұрын
I think the same results are accomplished by using Ctrl + A but I might be missing something.
@stilldrey5 жыл бұрын
CTRL+PgDn (navigate to another sheet) CTRL+PgUp (navigate up to the previous sheet)
@thaoporter53253 жыл бұрын
So happy to find her channel.
@EuropeanWorldTraveler3 жыл бұрын
This was so helpful. One I definitely didn't know of was "Flash Fill." Thank you for sharing the information in a very easy-to-follow video!
@relaxationlight66263 жыл бұрын
you can find it here kzbin.info/www/bejne/e4e5foKdqNR9eKM
@amineboutlikhetingenieurel82202 жыл бұрын
Excel shortcuts - a small session by Leila Gharani 00:00 Intro 00:13 Add / remove Excel Filter 00:40 Create an Excel Table 01:10 Navigate in Large Data Sets 01:27 Select a Range of Cells 01:55 Format Cells in Excel 02:09 Auto Sum 02:40 Paste as Values 03:11 Add a New Line Inside a Cell 03:31 Select All Data in Current Region 03:41 Insert Default Chart 03:48 Excel Flash Fill 04:23 Select Entire Row/Column 04:33 Insert a New Row/Column 05:09 Delete a Row/Column 05:24 Move a Cell/Row 05:54 Hide Column/Row 06:04 Check for Hidden Cells 06:27 Insert Time Stamp 06:43 Find Cells Without Formulas (Constants)
@saratmondal20002 жыл бұрын
Thanks
@VivekGupta19945 жыл бұрын
Ctrl+[ to go to the linked cell & F5+enter to return back.
@Lunatyk0015 жыл бұрын
This one is amazing! Thank you for that ;)
@XAE_A_Xii5 жыл бұрын
really, never thought about it. for mac, works the same, but to return back use ]
@XAE_A_Xii5 жыл бұрын
really, never thought about it. for mac, works the same, but to return back use ]
@zrorarahul19854 жыл бұрын
@@XAE_A_Xii you need to work hard
@alexkerr74364 жыл бұрын
I've been looking for this one forever..
@pakistaninternational.98552 жыл бұрын
I love to see you speaking in a great style.
@madhurareddy18983 жыл бұрын
When I watch this video. It so helpful to me. It's bit comfortable and progressing short cuts for everyone..it must learn
@tantraraasa9144 жыл бұрын
Ctrl+; (date) and Cltr+Shift+: (time), these are live (current) date and time. When we open the file next day or some other day, the date and time is updated.