Jonathan writes in to mention Ctrl ; enters todays date. In Episode 542, I run through several of my favorite shortcut keys, including Show Formulas, Visible Cells Only, and more.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Welcome back to the MrExcel netcast, I'm Bill Jelen.
I have an email today from Jonathan in the UK, Jonathan's going back to another podcast where I'd used the shortcut key control column to enter the time and Jonathan pointed out that it's also possible to enter the date and in similar fashion, so if you need to put in today's date the fast way to do that is control semicolon, we'll put in today's date just to quickly run through some other cool shortcut keys as I mentioned another podcast control shift column will give us the time, that kind of makes sense because if you think about the time it has a column in the middle that's easy to remember, if you need to make something bold control B for bold underlined, control U for underlying italics, control I for italics.
One of my favorite ones especially if you keep it to do list in Excel I'd love to be able to cross it out that's control 5 will apply Strike Through, some other cool shortcut keys we have if you want to see all of the formulas in your worksheet at one fell swoop on the US keyboards right below the f1 key you have a key that has a till day that's the squiggly line over the n in Spanish if you hold down the control key and hit that key in other keyboards it's the Groff it's the backwards accent, it will show you all of the formulas in your worksheet at one time it's a toggle so it goes back and forth, so again in the US that's control till date or control Grov the backwards accent usually underneath the f1 key on most US keyboards.
One more great shortcut we have is when we've added some automatic subtitles and we have the group and outline buttons if you go to the number to view or you see just the automatic subtotals and you want to copy that if we copied right now with control C and when somewhere else would get the detail lines as well, we want to select just the visible cells which is Alt semicolon that's the same as going to edit go to special visible cells only, CTRL C to copy and now when we pay somewhere else will get just the subtotal lines instead of all the detail lines as well, now those are some of my favorite shortcuts but there's hundreds of different shortcuts and you can find them all and Excel help, now if you really are a shortcut fan one of my favorite products is from a company called IdeasOn, they wrote to me a few years ago and I saw this keyboard and I thought was pretty cool I mean actually have a link right for my home page because I thought it was a great new way to learn shortcuts in fact that's how I learned strikethrough, basically what it is this; is a keyboard that comes in and then you buy a key set for Excel that shows all of the different shortcut keys right on the key, so here on the R key it shows that that is fill right, CTRL R is fill right, look at that there's one I didn't even know so right there at your fingertips you have all these different shortcut keys the Alt key is the control keys and you can learn how those work.
Pretty clever company they actually started this for gamers how you can get key sets for all the video games and I you know once you get past pong I've lost but I'm sure they have a keyboard for all the new video games and they also created one for Excel which is pretty cool, so if you're a nurse in that go to MrExcel.com, scroll down to the keyboard and click on the option and you can take a look at the ideas on keyboard for Excel.
Hey thanks Jonathan for sending in that note about control semicolon entering today's date and ran through a few other my favorite Excel shortcuts, I'm sure that you have yours thanks for stopping by.
Hey tomorrow is the fourth of July which is a holiday in the United States so we'll be back on Thursday for another podcast from MrExcel.
I have an email today from Jonathan in the UK, Jonathan's going back to another podcast where I'd used the shortcut key control column to enter the time and Jonathan pointed out that it's also possible to enter the date and in similar fashion, so if you need to put in today's date the fast way to do that is control semicolon, we'll put in today's date just to quickly run through some other cool shortcut keys as I mentioned another podcast control shift column will give us the time, that kind of makes sense because if you think about the time it has a column in the middle that's easy to remember, if you need to make something bold control B for bold underlined, control U for underlying italics, control I for italics.
One of my favorite ones especially if you keep it to do list in Excel I'd love to be able to cross it out that's control 5 will apply Strike Through, some other cool shortcut keys we have if you want to see all of the formulas in your worksheet at one fell swoop on the US keyboards right below the f1 key you have a key that has a till day that's the squiggly line over the n in Spanish if you hold down the control key and hit that key in other keyboards it's the Groff it's the backwards accent, it will show you all of the formulas in your worksheet at one time it's a toggle so it goes back and forth, so again in the US that's control till date or control Grov the backwards accent usually underneath the f1 key on most US keyboards.
One more great shortcut we have is when we've added some automatic subtitles and we have the group and outline buttons if you go to the number to view or you see just the automatic subtotals and you want to copy that if we copied right now with control C and when somewhere else would get the detail lines as well, we want to select just the visible cells which is Alt semicolon that's the same as going to edit go to special visible cells only, CTRL C to copy and now when we pay somewhere else will get just the subtotal lines instead of all the detail lines as well, now those are some of my favorite shortcuts but there's hundreds of different shortcuts and you can find them all and Excel help, now if you really are a shortcut fan one of my favorite products is from a company called IdeasOn, they wrote to me a few years ago and I saw this keyboard and I thought was pretty cool I mean actually have a link right for my home page because I thought it was a great new way to learn shortcuts in fact that's how I learned strikethrough, basically what it is this; is a keyboard that comes in and then you buy a key set for Excel that shows all of the different shortcut keys right on the key, so here on the R key it shows that that is fill right, CTRL R is fill right, look at that there's one I didn't even know so right there at your fingertips you have all these different shortcut keys the Alt key is the control keys and you can learn how those work.
Pretty clever company they actually started this for gamers how you can get key sets for all the video games and I you know once you get past pong I've lost but I'm sure they have a keyboard for all the new video games and they also created one for Excel which is pretty cool, so if you're a nurse in that go to MrExcel.com, scroll down to the keyboard and click on the option and you can take a look at the ideas on keyboard for Excel.
Hey thanks Jonathan for sending in that note about control semicolon entering today's date and ran through a few other my favorite Excel shortcuts, I'm sure that you have yours thanks for stopping by.
Hey tomorrow is the fourth of July which is a holiday in the United States so we'll be back on Thursday for another podcast from MrExcel.
