0102 The "One" Universal Shortcut and a Faster Copy-Paste Technique

Advanced Excel Crash Course Section 1: Ninja Shortcuts
3 minutes
Share the link to this page
Copied
  Completed

Transcript

Hi everyone, the next few minutes we are going to invest our time and effort in learning some of the shortcut keys which you will be using, definitely be using in times to come and cumulatively over the next few years, it's going to save you tons and tons of time. And of course, it would definitely impress the person sitting beside you and see how how quickly you're able to use shortcuts to perform the tasks. Now what I've done is I've hand picked some of the very, very important shortcut keys, which I'll be explaining to various examples. The first one is actually been introduced in 2007 version of Excel. For example, if you want to access a particular tab or a button from the ribbon, let's say is fill color, and I do not know the shortcut you do activate that then how do you activate that button without knowing the shortcut key?

Sounds like a contradictory statement? Well, actually no. Notice my scheme. If I press ALT key, automatically, the ribbon shows all the key tips and when I click on the letter H While he is actually indicating the Home tab, when I click on H, it further shows me key tips within the different components of the same tab home. Now notice carefully, the button which is showing you show fill color is also indicated by the letter H. So I will press h from the keyboard, and what happens the color palette opens up. And then I use the down and up or right arrow key to go to the favorite color.

Let's say in this case, the green and I press enter. So this was the power of all key. If you perhaps want to access another button, let's say alt H is for whom and then what I see I see the comma style or maybe general or maybe any of the format which indicates increase or decrease indent. Let me press digit six why six because this is present besides the button call increase indent which is six. As you can see, it definitely affects the text inside it. Now you would already be working with control C control x and control V. So I'm not going to that detail.

What else? Well, if you have any formula or a text, which you want to copy paste down, normally what people do, they use Ctrl C, and then they drag it and then press Control V. Well, alternative to this is you don't need to copy the entire single cell. In fact, once you simply choose the data, including the first cell, all you have to do is press Ctrl D Ctrl. D is a shortcut key. It includes the combination of Ctrl C, and Ctrl V vertically. Now similar to this is what we call us.

Ctrl R. It copy pastes the data automatically to the right hand side. So if I choose all the data from this particular selection, I choose a selection towards the right. If I press Ctrl R, notice what happens. Yes, so the key point here is you must choose the cell that you want to copy paste. So at times, if you want to save time instead of doing Ctrl C, Ctrl V, you will might as well use Ctrl D and Ctrl R. Well, I can send you a curiosity level. If you're thinking what about Ctrl L and Ctrl u?

Well, there is no control left and there is no control u which will copy paste the data upwards because Ctrl U is dedicated for underlining. So we'll see a couple of more shortcut keys in the upcoming series of videos on ninja shortcuts.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.