 Hello everyone and welcome back to another video. In this video I'm going to be looking at the best Shortcuts in Excel that you didn't know about. So we're going to go for this video We're going to run through each one of them individually with a quick example to show how it works And hopefully you'll learn something that you weren't already aware of in total I think it's just short of 20 shortcuts So I'll try and get through them as quickly but efficiently as possible so this video doesn't go on forever So the first one we have is sum all above or basically sum all your values In a table the best example is as you'll see here We've got auto sum totals So in the scenario where you might want to have a total of this first column here of this column separate And likewise for the rows and ending up with a total in the end here for all these numbers altogether We can achieve this really simply by just selecting all of this information and those blank columns at the end there And all we need to do is now hold down the alt key and then the equal sign and you can see it's automatically populated for us So for each of those totals is put the sum in there to give us the total for each of those individual ranges The next one we have to look at is current day So this is a great shortcut if you just want to get the current date So today's date all you need to do is hold down the control key and then hit the semi coding key And you can see that a day is automatically populated into that box So today's day is the 15th of April Following on from that But obviously slightly different is if you didn't want the date, but you wanted the time We have also a shortcut for that as well All we need to do this time is do control Shift and then the semi coden and you can see you can get the exact time as at the point of entering it in there So the exact point now is the 17 minutes past four So real to quick beneficial ones to have right there The next one we have when we're working with a workbook is we might want to like select the whole row So obviously we can quickly do that by selecting the row as so or if we know that this is the row We want to select row 19 as long as we're selected in that row All we need to do is hit the shift key followed by the space key and you can see it's automatically selected that row for us The following on from that the next one we might want to do is select the whole column This we can also really do by quickly going into the desired cell what is within that column and just do the control This time and space and you can see how that's now selected the whole column for us Know that we shortcut hadn't put us on the list But it's just what I want to do if you wanted to select the whole workbook All you do is do control a and you can see that that selects the whole workbook for you as well So a little bonus addition there for you as well Other than selecting and hiding rows. We might also wish to Hide rows or hide columns this can be done again easily So we select the desired row and all we need to do is do control and the number nine and you can see that that row is hidden I did that bit quick there. So I undo the control Z row 21 I see I'm selected within all I do is hold down the control key and then push the number nine and you can see that They're done and it's worth mentioning because I sort of skipped go long a few here with these commands when I say hold down shift And then the number nine you first hold down the control button and then hit those Following buttons afterwards what will obviously do this desired result and I'm just doing control Z here as well Just revert back to prior to making that change The other one again is hide columns So it's not much different to the last one hide and rolls All we need to do is do control and zero and you can see how that's now hit that row that column sorry for us Control Z go back again Next one might be okay. We want to delete a selected column or row. So in order to do that Let's say we've selected car row 21 here. Actually, let's go to the one where we've got some text So there's today's date here So let's say we want to select the rows if you go control nine Just oh no to hide it now if I want to do shift and space to select the row And in order to delete that select a row or an outing to do is hold down the control button and do the minus And you can see that row has now been completely deleted. So you can see we've got 18 19 20 So we can clearly see that's not been hidden. It has indeed been deleted So we just do control Z to go back there again Alternatively if I was to hit the column Well, it's gone to everything if I was to hit just the column So let's go control and space and this time do control and minus again You can see how that has automatically removed our column for us. So you're going to do real key little shortcuts there Alternately as you're probably aware, you can just right-click on the column or the row and you can then do your delete from there But the shortcut is the important of this is the thing we're focusing on in this video Next one. So we might want to do an enter a new line within the cell So this potentially comes in handy when you're typing text. So let's say we want to put in this This is my first row and if you're working with any other Text editor should we say well obviously Excel is not text editor But if you were and you wanted to go on to a new line to say this is my second line in Excel if you hit enter as you know, it'll go into a new cell But actually we want this to be a new line within the same cell So at the end of the text all we need to do here is we need to hold down the alt key this time and then hit the enter button and You can see it first. It looks like it's just removed our first line, but I will type here. This is my second line Hit enter and you can see at the moment we've got a bit of word wrap going on there But if I was to expand this column you can see how it's actually put my text into two separate rows And I can expand this at the top here just so you can see that again So if you wanted to do a third row as well again, hold down the alt key hit enter and it will now create a third row for you And if I can spell third that might help as well, let's do third So you get the idea and that's how that works when entering new rows within the same cell Next one we move on to is inserting a new sheet. So as you can see We've just got the single sheet here titled essential excel But let's say we want to add a new sheet to this workbook Very simply all we need to do is hold down the shift key and do f11 And you can see a new sheet title sheet for has gone in for us If you wanted to do another one again again shift f11 and we keep doing this as many times as we require So that then helps me follow on to the next one. So when we've got a number of sheets in our workbook Rather than sort of clicking here into the sheet because you know, sometimes you'll be typing away You don't want to keep going to your mouse. How can you navigate through all these sheets using shortcuts? Simple all you need to do is hold down the control button And this is to go move forward through your sheets. So if you hold down control and then use the page down button You can see we can now skip through each one of those sheets And it doesn't look didn't look like I was changing there much at all But obviously you're going through blank sheets, but hopefully it did when we got to existential excel at the end there Alternatively, if you want to go backwards through the sheets again, you hold control But this time we're going to be using page up So it's page up to go backwards through the sheets and page down to go forwards And hope you can see that updated on the screen there. So that is a really useful one I find myself using that quite a lot to be fair when jumping around different sheets and trying to compare information Cool. So the next one or the last the last little section Shall we say is looking on the formatting of cells and what I'm just going to do is just delete these sheets here Just to tidy up the page. So I've grouped them all together. Let's go delete There we go nice and tidy once again, and let's just scroll down the page ever so slightly to number formats down here So the first one to look at is formatting numbers with a comma format at the moment You can see our table is all in that general format. So we just got a bunch of numbers But the first one I want to do is format it into the comma format. So for the thousand So that'd be for one thousand five hundred and twenty As you can see in this first example, I want there to be a comma after that number one to correctly identify that It's one thousand five hundred and twenty What I'm going to do is just highlight this first column And then to get the actual comma formatting All I need to do is hold down my control shift and then number one button And you can see we've quite quickly got our commas in there to give us the More accurate representation representation of that number if I get the word representation out Number one we have so we'll keep moving through these is the currency format So let's go to the currency column and let's just do control shift from down again Just to highlight this column if you weren't aware of that shortcut again another bonus for this video But I'm sure you're probably already aware of that one So this one we want currency so it's exactly the same but this time this time we're going to do control shift and then the number four What will give us our default currency there? You can just default to two pounds for us here And then even along we can do the percentage one another one I find myself using quite a lot when we're trying to convert you can see a decimal number here into a percentage All we need to do is just do control shift down and this time we do control shift and the number five And you can see that's turned that into a nice percentage number for us And lastly in terms of these number formats, I'm just going to do a simple date format So we'll do highlight that little range This time slightly different was going to do control and then the hashtag And you can see that that's formatted it to a date for us there So that's how you can also use format That's how you can also use The shortcuts to format your numbers that you have now just notice it But apologies for this banner that keeps popping up But it's trying to get me to sign into office 365 And the very last one I have on my sheet here is how to return back to cell a1 So you know often you could be working in this sheet You might have a lot of data and you might end up far down here somewhere And all you want to do is go right back up to cell a1 Just so you can see how the page looks from that top corner All you need to do to do that is hold down your control button And then never use the home button on your keyboard so control then home And you can see it's jumped straight to cell a1 for us there So quite a quick and punchy little video there But hopefully we covered off a number of shortcuts that you weren't aware of And also as we've titled it the most useful excel shortcut keys We thought is really good one to share with you because there's often a number of shortcuts that you probably use every day Like control c and control v for paste But these shortcuts are ones that hopefully you'll find of great use And you'll find yourself using them every day now that you've learned them If it's the first video of ours that you've seen or if you've been a viewer of many other videos Please do subscribe to the channel and hit that bell notification button Therefore you'll be notified of all our future videos as they come out Lastly, thank you very much for watching and we'll see you in the next video Before you go don't forget to check out the other videos on our channel You'll see everything from other functions and formulas through to tips and tricks We've also created some playlist so you can see these categorized together So make sure you check those out and get all those useful information And obviously as always don't forget to subscribe and hit that bell notification button