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.
Hi Liela I would like to make a small request to give the most important and most used Excel functions in video form. Thankyou, the Excel videos you are making are great
Hoping you can help me. I have a multi sheet workbook that uses data from a main ledger sheet to a receipts sheet and a status report sheet, for a workplace Sunshine Fund. Is there a formula, shortcut, or way to build the receipt book and status report so that it isn't effected or corrupted if I have to add rows (New Employees/Members) to the main ledger? Thank you for any assistance you can offer!
Sometimes I get the Format Shape pane on the right and I can only close it by clicking its x. Do you know if there's a way to close it by keyboard short-cut? The Help pane (F1) can be close by Ctrl+spacebar+c, but it doesn't work for other side panes!
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
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!
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
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.
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
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.
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...
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.
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
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..
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..👏👏
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.
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
@@rldb Exactly. I like the universal Windows shortcut keys Ctrl+F4 and Alt+F4 for closing the current workbook vs closing Excel respectively just like closing current tab in a browser vs closing the browser. Cheers.
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)
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.
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.
@@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.
@@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.
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.
@@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).
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.
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 :)
@@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.
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
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
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...
@@venkateshdodigalla8574 CTRL+' only shows the formula in the above cell but is a great way to copy a formula esp if you need to work with it as it brings it up in edit mode, CTRL + ~ will show you all the formulas on the active sheet. Two great shortcuts but do different things.
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
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.
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.
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.
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.
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.
Ctrl +Shift + L to Add filter Ctrl+1 for formatting Alt+= for autosum Alt+enter to add a line inside a cell Alt+F1 insert chart Ctrl + and - add and remove rows Alt +; for hidden rows and columns F5 +alt +S O X for checking hidden formulas
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".
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)
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
Grab the file with all shortcuts from here 👉 pages.xelplus.com/excel-shortcuts-file
summited but not get mail dear Leila
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 ?
The best shortcut I know.... Alt - A - C which clears all filters, without turning off the filter option from the table
@Ali T a shortcut is defined as an alternative route to get from A to B, that is shorter than the one usually taken
@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 😂
@Ali T and to you, my friend… and to you
@@andywdrums gave a good chuckle there mate 😂
Hey, what ever the name it is, it works for me. Thanks.😊
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.
This Channel is the Excel for Learning
Presentations are so easy to follow.
You are a genius! You made my life easy and an easy Christmas 2021. Be blessed.
06:04 Check for Hidden Cells, Alt ; love it!!
Difficult, thousands of tips. Flash fill is very coom 😎
Ctrl+D copy above cell, it is very handy
Hi Liela I would like to make a small request to give the most important and most used Excel functions in video form. Thankyou, the Excel videos you are making are great
Hi @Leila Gharani, may you also include Mac version as well. Thank you!
Nice video
Alt+WF freeze panes
Thanks
Thanks 👍👍👍👍👍👍
Very useful
Hoping you can help me. I have a multi sheet workbook that uses data from a main ledger sheet to a receipts sheet and a status report sheet, for a workplace Sunshine Fund. Is there a formula, shortcut, or way to build the receipt book and status report so that it isn't effected or corrupted if I have to add rows (New Employees/Members) to the main ledger? Thank you for any assistance you can offer!
Sometimes I get the Format Shape pane on the right and I can only close it by clicking its x. Do you know if there's a way to close it by keyboard short-cut? The Help pane (F1) can be close by Ctrl+spacebar+c, but it doesn't work for other side panes!
Control + Alt + V and 2 times down arrow will do for 7
Ms Leila thanks for useful videos on excel and excel vba.
Can you create similar videos on vb.net
Julia Roberts teaching Excel. Beautiful!
I wish. Thanks though :)
@@LeilaGharani you are far more beautiful than her.
ctrl+0 is to hide columns and then how remove the hide columns, let me tell Leila
How can i link the portal in excel to run a macros
Ctrl + ; add today date to cell
Ctrl + Shift + ; to add now time
thank you
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
Ohh!! Thanks a lot!!
Good
Ctrl + k to create a hyperlink
Ctrl + u to expand the formula bar
Ctrl+Shift+U to expand the formulebar
Clear Filter (NOT Remove) = ALT + A + C
Unhide Row: CTRL + SHIFT + 9
Unhide Column: ALT + O + C + U
To paste as values, u can use "ctrl + Alt + V"
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!
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!
try Ctrl ] to get back
Thanks
@@renebartodziej3765 it works only in one sheet
Really great
I found Ctrl [ about 10 years ago, the whole team worked in linked spreadsheets so everyone was thrilled to learn it too.
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
Love these! Thanks for sharing Ajay.
@@LeilaGharani pleasure is all mine
Ctrl shift 8 to highlights all the data
Ctrl page up/down - for navigating through sheets
Yes, use this all the time
awesome Ajay. I like the navigating between sheets in excel, sweetness.
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.
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.
Just Wow.
Thanks Charles!
Paste Special box shortcut
Ctrl+Alt+V
Rohit Jain That is the shortcut that most colleagues ask me about: “How did you do that?!”
Oh good, that one is fairly easy to remember too!
The best one is menu key + V
I prefer Ctrl+V to paste and then ctrl followed by V to select paste values or Ctrl then M to paste unfromated text
Thank you Leila for the video, awesome. I Wana ask what is the tool you use to make your videos?
Just wondering why someone will thumb down on an awesome video like this.
Haters
Dumb people and there is plenty of those
Because they are morons.
They are stupid
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
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
F4 to repeat last action
F4 in formula to change relative/absolute reference
F4 is my favorite.
Repetition command in word
F4
Alt enter
Control Y
This woman is God-given.
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
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.
Love Alt IC and IR. You're right - very easy to remember!
thanks
It's Really Awesome & Fantastic
Incredible nice one
I'm using "Alt W F F" for freezing columns and rows which is very useful for me
Very useful alt w f f
I use Alt DFF
ctrl+pageup change sheets
ctrl+pagedown
shift+f2 comments
alt+f11 vba
Very helpful shortcuts. Thank you for sharing.
@@LeilaGharani h
Ctrl+[ to go to the linked cell & F5+enter to return back.
This one is amazing! Thank you for that ;)
really, never thought about it. for mac, works the same, but to return back use ]
really, never thought about it. for mac, works the same, but to return back use ]
@@XAE_A_Xii you need to work hard
I've been looking for this one forever..
U missed the imp one...i guess.....cntrl + page up/down to toggle between tabs in a worksheet
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...
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
menukey + v is also nice for pasting values, only if your right hand is free
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.
To paste as values,
I like to use the short cut
Alt+H+V+V
Easier to remember and quicker to insert
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
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..
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..👏👏
Her voice is awesome, i can improve my communication by listening to her
Cringe
Thirst...
Really useful. Just want to add one of mine, Ctr + ~ to show all the formulas in the sheet and same to hide.
This channel is so underrated !
I wish I'd found this years ago! Love from Brazil.
Thanks. Ctrl+] and Ctrl+[ to find related cells.
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.
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
find it here
ua-cam.com/video/EVVMOgsoJBA/v-deo.html
=NOW() will give you dynamic date and time
Oh great..
Alt+ H + O+ I. Auto fits cells/rows/columns to their contents
Alt+H+O+A . Fits the Row height to the Content
Hi All,
Alt Pg dn - move column wise right
Alt Pg up - move column wise left
Hope it's help 👍🙂
Thanks Leila
Ctrl+w to close an Excel file, but not the application - this shortcut I use quite often.
Ctrl+F4 does that not just in Excel but in Word, PowerPoint, Adobe PDF reader etc.
@@rldb Exactly. I like the universal Windows shortcut keys Ctrl+F4 and Alt+F4 for closing the current workbook vs closing Excel respectively just like closing current tab in a browser vs closing the browser. Cheers.
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)
Thanks
Thank you very much for all the short cut tricks. You are awesome!
Ctrl + alt + v is another shortcut for paste special
Shortcut key for capitalising letters??
For changing alphabet case..
Anyone know.. plz reply...
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.
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.
@@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.
@@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.
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.
@@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).
I use Alt H B A for giving all border
Yes am also using
Awesome lecture! It would be really helpful for the ppl working in actual field.
CTRL+PgDn (navigate to another sheet) CTRL+PgUp (navigate up to the previous sheet)
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.
awesome.......
Ctrl+i+c to add column
Ctrl+i+r to add row
Ctrl+e+d to delete column/row
That's a flash fill MAGIC!
This is the best excel training I found in my life. Microsoft should hire you
wow. nearly every one of those was a revelation! and I've considered myself a pretty solid Excel user....for the past 30 years!
That's great. Now you have a few more things in your toolbox that will hopefully help going forward.
we should know leila is a Queen of Excle thanks for every things
I am really enjoying these excel tips... They have been a very good source as a refresher courses for me! Thank you Leila
@@herlenebrown2383 please give regard call Leela mam👏👏👏
To copy in value I use ctrl+c for copy and then Ctrl+Alt+V V then Enter
*Ctrl +1* and *Ctrl+E* are awesome, Thanks
Careful with the Autosum if there are any blank cells in the column or row.
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 :)
@@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.
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
For paste as value: you can use ctrl C and then ctrl V and again Ctrl and after press V. My favourite and fastest.
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
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...
Easiest is ctrl C then you right click on the cell and press v
F5 Alt+S,O,X really blew my socks off!!!
Ctrl + ~ is a quicker way to see formulas
Not Ctrl +~
it is ctrl+`
@@venkateshdodigalla8574 enti bro sure ah
AA comment ki aldready ame like kuda kotindhi
Check chesuko
@@venkateshdodigalla8574 CTRL+' only shows the formula in the above cell but is a great way to copy a formula esp if you need to work with it as it brings it up in edit mode, CTRL + ~ will show you all the formulas on the active sheet. Two great shortcuts but do different things.
@@gnbyrne if you want ~ you need to hold shift key
Without shift key it is '
If you press ctrl +' then it will show all the formulae in work book.
@@sandeeppeddi7075 one try both formulae bro
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
Which is cmd button on keyboard
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.
Use this all the time. Love this for large ranges. Very fast way to verify the correct selected range.
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.
Uppercase I or lower case l?
@@cl8wnm5n it doesn’t matter
Glad you posted this, these are the ones I use 😀
You're my best teacher in excel
F12 to bring up save as
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.
These are great! Thank you for sharing.
nikhil verma thanks for sharing. I have been looking to new sheet shortcut for a while
Great!
Thanks for sharing👍👍
These are great!
F2 allows you to edit inside a cell instead of double clicking inside a cell with your mouse.
Alt E L to delete sheet & Alt E M to move/copy sheet.
Just be careful with Alt+E,L. You can't undo. XD
Ma’am, you just saved my professional life. Thank you very much!
My pleasure Karim. Glad it's helpful.
I like your teaching
You have good technique and amazing for me
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.
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.
Great to hear!
Ctrl+tilda, squiggly key below Escape key, shows the formulas behind the value.
Great video by the way!
F2 will do.
@@BulkCarrierChiefMate try it once and u can feel the difference
Ctrl +Shift + L to Add filter
Ctrl+1 for formatting
Alt+= for autosum
Alt+enter to add a line inside a cell
Alt+F1 insert chart
Ctrl + and - add and remove rows
Alt +; for hidden rows and columns
F5 +alt +S O X for checking hidden formulas
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".
hey! Leila, i need a suggestion that which is the best one GOOGLE SLIDES(OR) Ms.Excel ? & what do you suggest . please comment ... or reply
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)
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
tip number 14 doesn't really work on my PC, unless you also press the shift key. so to add a column, highlight the column, then press CTRL + SHIFT + =
Any shortcut to unhide all hidden rows or columns
Unhide a row: CTRL + Shift + 9
Unhide a column: Alt + O + C + U
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
Ctrl + * (the star/ multiply sign) selects all of the data - even if there are empty spaces or gaps
I think the same results are accomplished by using Ctrl + A but I might be missing something.
I am really enjoying this channel. Your videos have been a great help.
I'm glad to hear that :)