Excel Shortcuts You SHOULD Know!

Поділитися
Вставка
  • Опубліковано 21 лис 2024

КОМЕНТАРІ • 1,5 тис.

  • @LeilaGharani
    @LeilaGharani  Рік тому +2

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

    • @shahidulhasansarker
      @shahidulhasansarker 9 місяців тому +1

      summited but not get mail dear Leila

    • @divesh.gawshinde
      @divesh.gawshinde 3 місяці тому

      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 ?

  • @sumedhdandekar8604
    @sumedhdandekar8604 4 роки тому +5

    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.

  • @chetswaman
    @chetswaman 5 років тому +18

    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

  • @AjayAnandXLnCAD
    @AjayAnandXLnCAD 5 років тому +49

    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

    • @LeilaGharani
      @LeilaGharani  5 років тому +4

      Love these! Thanks for sharing Ajay.

    • @AjayAnandXLnCAD
      @AjayAnandXLnCAD 5 років тому

      @@LeilaGharani pleasure is all mine

    • @ExcelSquad
      @ExcelSquad 5 років тому +2

      Ctrl shift 8 to highlights all the data

    • @hrleif8994
      @hrleif8994 2 роки тому

      Ctrl page up/down - for navigating through sheets
      Yes, use this all the time

    • @kevincecchini
      @kevincecchini 9 місяців тому

      awesome Ajay. I like the navigating between sheets in excel, sweetness.

  • @Haobey
    @Haobey 3 роки тому +5

    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

  • @practicalbusinesstips5591
    @practicalbusinesstips5591 5 років тому +204

    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!

    • @renebartodziej3765
      @renebartodziej3765 5 років тому +10

      try Ctrl ] to get back

    • @nomiims
      @nomiims 5 років тому

      Thanks

    • @heisnod
      @heisnod 5 років тому +2

      @@renebartodziej3765 it works only in one sheet

    • @kari8070
      @kari8070 4 роки тому

      Really great

    • @Tomm9y
      @Tomm9y 2 роки тому +2

      I found Ctrl [ about 10 years ago, the whole team worked in linked spreadsheets so everyone was thrilled to learn it too.

  • @spacemafia69
    @spacemafia69 3 роки тому +26

    This woman is God-given.

  • @vishalgala1079
    @vishalgala1079 5 років тому +60

    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.

  • @emmalungulesei9418
    @emmalungulesei9418 Рік тому +1

    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!

  • @BasuYadwad
    @BasuYadwad 3 роки тому +17

    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..

  • @subhasispatnaik975
    @subhasispatnaik975 5 років тому +7

    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..👏👏

  • @VarunBanala
    @VarunBanala 3 роки тому +8

    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

  • @tom_something
    @tom_something 3 роки тому +30

    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!

  • @erinkirby2649
    @erinkirby2649 3 роки тому +5

    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-ux2ep
      @VN-ux2ep 3 роки тому

      If you didn’t already know these shortcuts, then you probably are a beginner in Microsoft Excel and you’re surrounded by idiots!🤨🤨🤨🤨

  • @crice74
    @crice74 5 років тому +52

    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.

  • @martapunsola2025
    @martapunsola2025 3 роки тому +4

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

  • @clairejsquibb
    @clairejsquibb 5 років тому +8

    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.

  • @Raj2erum
    @Raj2erum 5 років тому +78

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

  • @raheelaarshad7669
    @raheelaarshad7669 4 роки тому +1

    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.

  • @joem112
    @joem112 5 років тому +28

    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.

    • @LeilaGharani
      @LeilaGharani  5 років тому +5

      Love Alt IC and IR. You're right - very easy to remember!

    • @nomiims
      @nomiims 5 років тому +1

      thanks

    • @itsmesarvesh
      @itsmesarvesh 3 роки тому

      It's Really Awesome & Fantastic

    • @oneoneday
      @oneoneday 2 роки тому

      Incredible nice one

  • @wayneedmondson1065
    @wayneedmondson1065 5 років тому +2

    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!

    • @LeilaGharani
      @LeilaGharani  5 років тому +1

      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.

    • @wayneedmondson1065
      @wayneedmondson1065 5 років тому +2

      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!

    • @heycarmiv
      @heycarmiv 2 роки тому

      Great tips thanks !

  • @nikhilverma1044
    @nikhilverma1044 5 років тому +12

    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.

    • @LeilaGharani
      @LeilaGharani  5 років тому

      These are great! Thank you for sharing.

    • @joemjoza9803
      @joemjoza9803 5 років тому

      nikhil verma thanks for sharing. I have been looking to new sheet shortcut for a while

    • @varunkhadke8467
      @varunkhadke8467 5 років тому

      Great!
      Thanks for sharing👍👍

    • @gnbyrne
      @gnbyrne 4 роки тому

      These are great!

  • @abdrahman6172
    @abdrahman6172 5 років тому +1

    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.

  • @andywdrums
    @andywdrums 3 роки тому +84

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

    • @andywdrums
      @andywdrums 2 роки тому +4

      @Ali T a shortcut is defined as an alternative route to get from A to B, that is shorter than the one usually taken

    • @andywdrums
      @andywdrums 2 роки тому +3

      @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 😂

    • @andywdrums
      @andywdrums 2 роки тому

      @Ali T and to you, my friend… and to you

    • @realeyesrealisereallies97
      @realeyesrealisereallies97 Рік тому

      @@andywdrums gave a good chuckle there mate 😂

    • @chakrapani2012
      @chakrapani2012 Рік тому

      Hey, what ever the name it is, it works for me. Thanks.😊

  • @imranmohammed2644
    @imranmohammed2644 5 років тому +19

    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.

  • @MrSubasish
    @MrSubasish 3 роки тому +27

    This channel is so underrated !

  • @alonsohernandez9779
    @alonsohernandez9779 3 роки тому +25

    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

  • @friendsanfriends12
    @friendsanfriends12 5 років тому +13

    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.

    • @cl8wnm5n
      @cl8wnm5n 3 роки тому

      Uppercase I or lower case l?

    • @566johncena
      @566johncena 3 роки тому

      @@cl8wnm5n it doesn’t matter

    • @kobostinywings
      @kobostinywings 2 роки тому

      Glad you posted this, these are the ones I use 😀

  • @MohammadJNematollahi
    @MohammadJNematollahi 5 років тому +75

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

  • @Lykoskia
    @Lykoskia 5 років тому +16

    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...

    • @LactatingPlatypus
      @LactatingPlatypus 2 роки тому

      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

    • @salala182
      @salala182 2 роки тому

      menukey + v is also nice for pasting values, only if your right hand is free

  • @kentturner9264
    @kentturner9264 3 роки тому +1

    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.

    • @LeilaGharani
      @LeilaGharani  3 роки тому +1

      Thank you! I'm so glad it's helpful for you.

  • @juanpedroleon-cl
    @juanpedroleon-cl 5 років тому +34

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

    • @crice74
      @crice74 5 років тому +2

      F4 is my favorite.

    • @bharatjha762
      @bharatjha762 3 роки тому

      Repetition command in word
      F4
      Alt enter
      Control Y

  • @Soulenergy31
    @Soulenergy31 5 років тому

    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!!

    • @LeilaGharani
      @LeilaGharani  5 років тому +1

      Great! Thank you for sharing :)

  • @NOOBY9
    @NOOBY9 4 роки тому +4

    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".

  • @thomassentilhes7147
    @thomassentilhes7147 5 років тому +2

    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

    • @LeilaGharani
      @LeilaGharani  5 років тому +3

      I'm glad you found something useful Thomas.

  • @k.saikumarreddy357
    @k.saikumarreddy357 5 років тому +41

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

  • @saugata2
    @saugata2 4 роки тому +2

    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. :)

  • @doncogleone646
    @doncogleone646 5 років тому +13

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

  • @hybriddude007
    @hybriddude007 2 роки тому

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

  • @derekeyler2634
    @derekeyler2634 2 роки тому +10

    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

  • @MatteoTomaselli
    @MatteoTomaselli 3 роки тому

    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!

  • @adityasharma0101
    @adityasharma0101 4 роки тому +11

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

    • @jayaramb2343
      @jayaramb2343 3 роки тому

      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

  • @xlezpk
    @xlezpk 5 років тому +6

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

  • @EmpiricalPragmatist
    @EmpiricalPragmatist 4 роки тому +5

    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.

  • @Ramkumar-de1pf
    @Ramkumar-de1pf 4 роки тому +1

    Alt + =
    F5, Alt s. Is new to me...
    Your videos are really awesome and advanced, I get always something new every time I watche a video of yours even about known topic.

  • @rishabhmehta3364
    @rishabhmehta3364 5 років тому +5

    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.

    • @djstone5518
      @djstone5518 3 роки тому

      Use this all the time. Love this for large ranges. Very fast way to verify the correct selected range.

  • @XAE_A_Xii
    @XAE_A_Xii 5 років тому +4

    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

  • @shahidansari-om8hk
    @shahidansari-om8hk 5 років тому +41

    You're my best teacher in excel

  • @tfbiv427
    @tfbiv427 4 роки тому +1

    Some shortcuts I learned recently that I now use all the time: (1) select a range of cells with values in the first row and hit ctrl-D to copy down all the formulas; (2) to copy the value in the cell above the selected one, just hit ctrl-' (apostrophe). I use ctrl-; and ctrl-: (date and time) a lot. I'm going to try to remember the row and column insert and delete shortcuts and try out the instant chart key Alt-F1. Thanks for this very useful content!

  • @katewaller5695
    @katewaller5695 2 роки тому +4

    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.

  • @anikchowdhury9708
    @anikchowdhury9708 2 роки тому

    Thanks a lot Leila,one shortcut I learnt is ALt+W+F+R to freeze the top row

  • @DavidWonn
    @DavidWonn 4 роки тому +22

    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.

    • @TrilobitesRTasty
      @TrilobitesRTasty 3 роки тому +2

      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.

    • @DavidWonn
      @DavidWonn 3 роки тому

      @@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.

    • @TrilobitesRTasty
      @TrilobitesRTasty 3 роки тому

      @@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.

    • @DavidWonn
      @DavidWonn 3 роки тому

      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.

    • @TrilobitesRTasty
      @TrilobitesRTasty 3 роки тому

      @@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).

  • @AbizerPardawala
    @AbizerPardawala 4 роки тому +1

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

  • @Oppadu
    @Oppadu 5 років тому +7

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

  • @sharbhanu
    @sharbhanu 3 роки тому +2

    @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 🙏🙏🙏

  • @ekscaps6425
    @ekscaps6425 4 роки тому +3

    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.

  • @pravinshingadia7337
    @pravinshingadia7337 4 роки тому

    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!

  • @joep9617
    @joep9617 5 років тому +5

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

    • @satyavijay4913
      @satyavijay4913 5 років тому

      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 :)

    • @djstone5518
      @djstone5518 3 роки тому

      @@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.

  • @EuropeanWorldTraveler
    @EuropeanWorldTraveler 3 роки тому

    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!

    • @relaxationlight6626
      @relaxationlight6626 3 роки тому

      you can find it here
      ua-cam.com/video/EVVMOgsoJBA/v-deo.html

  • @amineboutlikhetingenieurel8220
    @amineboutlikhetingenieurel8220 2 роки тому +39

    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)

  • @WalinMusa
    @WalinMusa 2 роки тому +1

    Hi Leila, thats an excellent video, I must say. A lot of learning and this video is worth watching. I just have one small query regarding Shortcut # 19 Check for hidden Cells.
    I hide first column of my data set, and when i press Alt + :
    its not giving me an indication whether something is hidden or not. however for other columns, it is working fine. Similarly, for the top most row, its the same.
    I hope you understood my query.
    anyways thanks a lot for such an informative video.

  • @georgeem8924
    @georgeem8924 4 роки тому +20

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

  • @steffenfischer5669
    @steffenfischer5669 2 роки тому +1

    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!

  • @rishabhmehta3364
    @rishabhmehta3364 5 років тому +48

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

    • @lgvdbroek
      @lgvdbroek 3 роки тому +3

      Ctrl+Shift+U to expand the formulebar

  • @AbhishekTripathidce
    @AbhishekTripathidce 4 роки тому +1

    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

  • @lightning6718
    @lightning6718 5 років тому +9

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

  • @akshayaeaswar5561
    @akshayaeaswar5561 3 роки тому

    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

  • @phvaguiar
    @phvaguiar 5 років тому +14

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

  • @gt3726b
    @gt3726b 5 років тому +1

    Nice.
    One I use all the time, - When in edit mode with cursor on a cell reference (like when entering formulas), the "F4" key changes the reference between all of the relative and absolute variations. Beats the heck out of typing in dollar signs.

    • @LeilaGharani
      @LeilaGharani  5 років тому

      This really saves time and hassle. Thanks James.

  • @arkhamknight4343
    @arkhamknight4343 5 років тому +3

    Alt + d + f + s to remove filter when there is a larger column sheet of filter so we dont know exactly were the filter is and one great feature of this shortcut is that it doesnt remove the filter entirely instead it clear the filters we had put earlier.

  • @AI-ec2qb
    @AI-ec2qb 4 роки тому

    Wow ma habibi! One time, a girl told me "You're so Smart" because I made a program in VBA with Excel, When I saw your video, Im like... I cant believe I never knew all this... You have given me more knowledge! Blessings Leila👩‍💻...

    • @LeilaGharani
      @LeilaGharani  4 роки тому

      I‘m glad you find the videos useful :)

  • @stilldrey
    @stilldrey 5 років тому +13

    CTRL+PgDn (navigate to another sheet) CTRL+PgUp (navigate up to the previous sheet)

  • @MsOfficeLearning
    @MsOfficeLearning 4 роки тому

    This Channel is the Excel for Learning

  • @Success_Mantra82
    @Success_Mantra82 5 років тому +4

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

  • @benfriendship
    @benfriendship 3 роки тому

    I want to say thank you for this useful video!
    Even if i have work with excel for more than ten years, i don't know all these shortcut!
    Thank you at all.

  • @karimal-mufakkir4041
    @karimal-mufakkir4041 4 роки тому +4

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

  • @sandratruax715
    @sandratruax715 2 роки тому

    Wish I would have seen this before I retired. I could have used this nearly daily! Love your tips. Thanks for sharing.

  • @vincentafnan-murray4850
    @vincentafnan-murray4850 4 роки тому +2

    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
      @sethuca4129 2 роки тому

      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

  • @khawajaaamirali2536
    @khawajaaamirali2536 5 років тому

    Best online teacher, the way to teach is awesome.

  • @nd7am
    @nd7am 5 років тому +49

    ctrl+pageup change sheets
    ctrl+pagedown
    shift+f2 comments
    alt+f11 vba

  • @Dulitzlives
    @Dulitzlives 3 роки тому +2

    FANTASTIC TIPS!!
    Is there a fast way to highlight a color to every other row of data?

    • @viksin1998
      @viksin1998 3 роки тому +1

      You can try format painter. Select the data row where the color is set. Select format painter and ctrl +shift + down arrow key. Works for me.

    • @Dulitzlives
      @Dulitzlives 3 роки тому

      @@viksin1998 Thank you !
      One quick edit, if I may respectfully, you need to select both the initial highlighted cell and the unhighlighted one below, and THEN go to format painter, control, shift, down.
      It will highlight then every other cell.

  • @kvlpnd
    @kvlpnd 5 років тому +7

    For paste as value: you can use ctrl C and then ctrl V and again Ctrl and after press V. My favourite and fastest.

    • @gt5713
      @gt5713 5 років тому +3

      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

    • @haerfrro1
      @haerfrro1 5 років тому +2

      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...

    • @junelagbas1505
      @junelagbas1505 5 років тому

      Easiest is ctrl C then you right click on the cell and press v

  • @bridgetteyoung964
    @bridgetteyoung964 3 роки тому +1

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

  • @baba_agba
    @baba_agba 3 роки тому +92

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

    • @truthseeker7833
      @truthseeker7833 3 роки тому +3

      Haters

    • @MrSnobby24
      @MrSnobby24 3 роки тому +2

      Dumb people and there is plenty of those

    • @cb9532
      @cb9532 3 роки тому +1

      Because they are morons.

    • @Dulitzlives
      @Dulitzlives 3 роки тому +1

      They are stupid

    • @bijubabloo5309
      @bijubabloo5309 3 роки тому +2

      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

  • @animecross9774
    @animecross9774 2 роки тому

    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.

  • @bschena
    @bschena 5 років тому +5

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

    • @LeilaGharani
      @LeilaGharani  5 років тому +3

      That's great. Now you have a few more things in your toolbox that will hopefully help going forward.

  • @dfsupport
    @dfsupport Рік тому +1

    Another awesome video! Shortcuts make my job so much easier!

  • @Softwaretrain
    @Softwaretrain 5 років тому +11

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

  • @thesoniexpedition
    @thesoniexpedition Рік тому

    Amazing video... helped me revise well. Thnx. The other common formula we used was alt+ h+ n or select any colour to add colour

  • @Jack.___
    @Jack.___ 5 років тому +10

    Ctrl + * (the star/ multiply sign) selects all of the data - even if there are empty spaces or gaps

    • @frankrichardcaruso6719
      @frankrichardcaruso6719 3 роки тому

      I think the same results are accomplished by using Ctrl + A but I might be missing something.

  • @pakistaninternational.9855
    @pakistaninternational.9855 3 роки тому

    I love to see you speaking in a great style.

  • @karthikeyans7539
    @karthikeyans7539 4 роки тому +4

    Hi All,
    Alt Pg dn - move column wise right
    Alt Pg up - move column wise left
    Hope it's help 👍🙂
    Thanks Leila

  • @thangaveluraj5366
    @thangaveluraj5366 4 роки тому +1

    Your videos are extensive and indepth, thank you very much.
    A request: please let me know how to learn Excel Macros easily. I have tried so far it's confusing. Appreciate if you make an exhaustive video.

    • @LeilaGharani
      @LeilaGharani  4 роки тому

      You can't really learn VBA and Macros with one video. I have a 22+ hours course on this topic in case you're interested.

  • @VivekGupta1994
    @VivekGupta1994 5 років тому +91

    Ctrl+[ to go to the linked cell & F5+enter to return back.

    • @Lunatyk001
      @Lunatyk001 5 років тому

      This one is amazing! Thank you for that ;)

    • @XAE_A_Xii
      @XAE_A_Xii 5 років тому

      really, never thought about it. for mac, works the same, but to return back use ]

    • @XAE_A_Xii
      @XAE_A_Xii 5 років тому

      really, never thought about it. for mac, works the same, but to return back use ]

    • @zrorarahul1985
      @zrorarahul1985 5 років тому

      @@XAE_A_Xii you need to work hard

    • @alexkerr7436
      @alexkerr7436 4 роки тому

      I've been looking for this one forever..

  • @BOWENSblog
    @BOWENSblog 4 роки тому

    Good to watch your random videos to expand my knowledge and also support a growth-mindset

  • @dennissamual
    @dennissamual 5 років тому +14

    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.

    • @AliensTech
      @AliensTech 4 роки тому

      The way she present is stunning.. Clear Explanation..Got some ideas for my Videos 😎

  • @MikoKohmaria
    @MikoKohmaria 3 роки тому +1

    Use Alt + : to select only visible cells and not select the hidden cells. This works very well for me. Especially when I want to copy paste only the visible data. Hope this helps the tribe here :)

  • @Simlaoui
    @Simlaoui 5 років тому +6

    thank you for your sharing. to convert formula to resulat i just hit 3 keys: F2 then F9 then Enter . then the formula is gone because it's converted to value. all the best . thank you.

  • @michaelb1785
    @michaelb1785 4 роки тому +1

    Very useful, thanks.

  • @RohitJain-dm1jk
    @RohitJain-dm1jk 5 років тому +150

    Paste Special box shortcut
    Ctrl+Alt+V

    • @TSSC
      @TSSC 5 років тому +4

      Rohit Jain That is the shortcut that most colleagues ask me about: “How did you do that?!”

    • @JBB685
      @JBB685 5 років тому +1

      Oh good, that one is fairly easy to remember too!

    • @VivekGupta1994
      @VivekGupta1994 5 років тому +10

      The best one is menu key + V

    • @petersaunders2413
      @petersaunders2413 5 років тому +5

      I prefer Ctrl+V to paste and then ctrl followed by V to select paste values or Ctrl then M to paste unfromated text

    • @Yacine_hass
      @Yacine_hass 5 років тому

      Thank you Leila for the video, awesome. I Wana ask what is the tool you use to make your videos?