Top 50 Microsoft Excel Shortcut Keys - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Darius
a story from a very long time ago I first learned spreadsheets before computer mice were common, and many things were in DOS (before WIndows). Keyboard shortcuts were the only way to do things, along with Function keys. Then when Windows and computer mice came along it seemed like all the young people were using the mouse and right clicking or left clicking on things, and it was just the old people who used the keyboard shortcuts. So I kind of forgot many of the keyboard shortcuts for a few years, but then other people were all saying the shortcuts were faster so I took the effort to learn them again.
reply
a story from a very long time ago I first learned spreadsheets before computer mice were common, and many things were in DOS (before WIndows). Keyboard shortcuts were the only way to do things, along with Function keys. Then when Windows and computer mice came along it seemed like all the young people were using the mouse and right clicking or left clicking on things, and it was just the old people who used the keyboard shortcuts. So I kind of forgot many of the keyboard shortcuts for a few years, but then other people were all saying the shortcuts were faster so I took the effort to learn them again.
reply
terrorsz75
This was super helpful. Thank you! I actually have one request for a shortcut, I saw it used a few years ago and can't remember what keys to use. So, working if formulas referencing different worksheet there was a shortcut key which is almost like F2 function when the formula cell is selected but it takes you to the actual cell the formula is referencing. Do you know what keys those are?
reply
This was super helpful. Thank you! I actually have one request for a shortcut, I saw it used a few years ago and can't remember what keys to use. So, working if formulas referencing different worksheet there was a shortcut key which is almost like F2 function when the formula cell is selected but it takes you to the actual cell the formula is referencing. Do you know what keys those are?
reply
Naan
Hello Kevin. Could you tell me how to open 2 spreadsheets at the same time in Teams/SharePoint files? If we have to transfer data from one spreadsheet to another, it's very clunky to open, close, open, close to pull and enter data into separate spreadsheets. Thank you so much. Shout out from Redmond! Sharing your info in our company.. We love your lessons.
reply
Hello Kevin. Could you tell me how to open 2 spreadsheets at the same time in Teams/SharePoint files? If we have to transfer data from one spreadsheet to another, it's very clunky to open, close, open, close to pull and enter data into separate spreadsheets. Thank you so much. Shout out from Redmond! Sharing your info in our company.. We love your lessons.
reply
Denise
I love this, you have made my job so much easier. I do have a question. I was (Making a correction)working on the middle of my spreadsheet. I had to go to the end to add more info. How do I get back to that spot I was working on without having to scroll up. Is there a shortcut to go back to the last spot I was making a correction on?
reply
I love this, you have made my job so much easier. I do have a question. I was (Making a correction)working on the middle of my spreadsheet. I had to go to the end to add more info. How do I get back to that spot I was working on without having to scroll up. Is there a shortcut to go back to the last spot I was making a correction on?
reply
KALAK
Kevin great video. Ques. what formula to subtract between cells using a large volume of values. ex, cell A1 minus cell C1 with answer in B1. repeating like that again with values in D1 minus F1 with answer in E1? repeating . I am wondering how to tell excel to just subtract into the empty cells between the two values
reply
Kevin great video. Ques. what formula to subtract between cells using a large volume of values. ex, cell A1 minus cell C1 with answer in B1. repeating like that again with values in D1 minus F1 with answer in E1? repeating . I am wondering how to tell excel to just subtract into the empty cells between the two values
reply
Goway
There are short keys worth mentioning that not covered in this video. After selecting row(s) or column(s) by using the shortcut key as illustrated in this video, press Ctrl + minus sign to delete, Ctrl + Shift + plus sign to insert
reply
There are short keys worth mentioning that not covered in this video. After selecting row(s) or column(s) by using the shortcut key as illustrated in this video, press Ctrl + minus sign to delete, Ctrl + Shift + plus sign to insert
reply
Emre
His Kevin,
I think this is begginer tutorial. There are more advanced shortcuts.
I-m waiting for this tutorial (for example: Ctrl+Alt+V = paste special or Ctrl+double C = pane window) -
reply
His Kevin,
I think this is begginer tutorial. There are more advanced shortcuts.
I-m waiting for this tutorial (for example: Ctrl+Alt+V = paste special or Ctrl+double C = pane window) -
reply
edmar
help me , How can I get the sum of my IMEI and Mac address using MS Excel? After getting the sum and multiplied by 11, how can I execute -nck- calculation in Ms Excel?
reply
help me , How can I get the sum of my IMEI and Mac address using MS Excel? After getting the sum and multiplied by 11, how can I execute -nck- calculation in Ms Excel?
reply
gohst101
its helpful , and useful but how I'm going to memorize all of them it will take lots of time to do but better to understand it first and practice -
reply
its helpful , and useful but how I'm going to memorize all of them it will take lots of time to do but better to understand it first and practice -
reply
Bryan
Hey Kevin, I'm trying to use this on MacOS, is it possible? I always use those keyboard shortcuts on windows but now i'm in a trouble.
reply
Hey Kevin, I'm trying to use this on MacOS, is it possible? I always use those keyboard shortcuts on windows but now i'm in a trouble.
reply
Add a review, comment
Other channel videos
