Updated April 14, 2023
Part -27 – Microsoft Excel Shortcuts
Transcript For The Video – Microsoft Excel Shortcuts
Microsoft Excel Shortcuts Keys:
Let us now move to the selection of Microsoft Excel shortcuts and learn these top seven Microsoft Excel shortcuts. So the first one is basically is SHIFT and SPACEBAR; how can we go about selecting a row? The traditional way is that you can use your mouse and just click on the row you want to select. The other way, however, could be to use your Microsoft Excel shortcuts, so that would be just used SHIFT and SPACEBAR. Let us say if I want to select this row number 8, SHIFT, and SPACEBAR. So by this, you are selecting the full row. Now look at number 2 and number 3; after selecting a row, if you want to insert a row, this is CTRL and + (plus); and CTRL and –(minus) to delete a row, say, for example, let me create a couple of rows here or data points. If I want to insert a row in between, I can select this row first, SHIFT and SPACEBAR, and CTRL and + in order to insert a row. So this how I can go about inserting a row. Inserting a row consists of two parts one choose the function to choose the row SHIFT and SPACEBAR and then CTRL and +, and if I want to delete a row, it’s basically after you have selected the row, you can choose CTRL and a minus sign. So this is how you can go about deleting the row. So we have looked at selecting a row, inserting a row, and deleting a row now. What about the columns? So let me do the data population here in this set if columns CTRL and SPACEBAR, so if I want to select this column, the shortcut is very simple CTRL and SPACEBAR, and for the row, you can see the difference, it was SHIFT and SPACEBAR, and here it is CTRL and SPACEBAR. So what if I want to insert a column? Just press CTRL and +. After selecting the column, and if I want to delete the column, look at CTRL and – (minus sign), so you can do that very seamlessly if you use these Microsoft Excel shortcuts. Sometimes I want to kind of format full worksheet and select the entire worksheet from top to bottom, left to right, at once. So this may also be a very tedious task sometimes. You can also look at using your mouse and just selecting from the top here, so this will select the full worksheet area however, you have another Microsoft Excel shortcuts as CTRL and A. If you want to select a entire worksheet so, just click at CTRL and A, and you will find that you can actually choose the entire area in this case and CTRL and A in order to select the full worksheet. However, you have another Microsoft Excel shortcuts which will help you to select an entire worksheet, and that is CTRL and A. So let us say if you are here, and you want to select the entire worksheet. You can just press CTRL and A to select the full worksheet, so what I was doing by clicking here using the mouse. I can achieve the same thing by pressing CTRL and A. So these are the selection of Microsoft Excel shortcuts that are very useful. Let us look at the top 8 Microsoft Excel shortcuts while we work with data. The first one, which is ENTER, is very familiar; when you are typing anything. Let us say a number; you can just type and press ENTER to move to the next cell, so this function is very easy to understand. The interesting one could be the second one, ALT+ENTER, so insert a new line within a cell; what does this mean? Let us say I am typing this data; let us say something like the text “working with data,” and if I press ENTER now without the ALT, what happens is that I am taken to the next cell. Hence, from cell number C13 to cell number C14, this is what happens, but let us say if I want to go back and now if I press ALT and ENTER, what happens is it inserts a new line within a cell. So this function is very useful to let us say I want to write 8 functions here, so the 8 functions are written within the cell, and if you format it a bit, you can see it is properly written in text format. So you can insert a new line within a cell using this. Let us say if I want to edit a cell in fact, I use this Microsoft Excel shortcut very frequently, which is F2. So I want to let us say edit the cell and write, I want to delete this 8 function I can do that by double clicking the cell and selecting this, and deleting it that is what I can do. However, I can also press F2; F2 is basically I want to enable the editing within the cell. So just choose any cell, press F2, and you are taken inside the cell. So you can do all your editing within the cell, say, for example, I want to go back to 25000. I want to edit the cell, press F2 and do your editing, and press ENTER. So this is how you can use this function, which is F2, which is very very simple to understand and use CTRL+C is copy, and CTRL+V is paste. I think the most important functions would be these; within the working with data class CTRL and C, I want to copy number 25 and paste it here CTRL+C. Once I do the copy, you can see this selection area gets highlighted, and what happens CTRL+V will enable me to paste the content so CTRL+V, the moment I do that, the same content gets pasted in the selected cell. So I want to paste it here so CTRL+V, so CTRL+C, and CTRL+V, so what is the difference between CTRL+C and CTRL+X? Cut the selected text or object to the clipboard, so let us say now I am pressing CTRL+X to understand what is cut CTRL and X. Now let me paste it here and see what happens CTRL+V is for the paste, so what happens is it gets cut from the original location. It gets pasted to the new location, so very helpful command if you don’t want to duplicate the content like this, you can just CTRL+X, cut, and CTRL+V, which is paste. So this is how you can really work. CTRL+Y, which means repeat the last action, OK. Let me show you let us say the last action is I have chosen the number 25, and I have made this in a blue font, so this is my last action. So if I want to redo the same thing to this new number 25, I may do it from here, or I can use this Microsoft Excel shortcut called CTRL+Y. So let me do it CTRL+Y. So the moment I press this CTRL+Y, the last action gets repeated again. I can do this same thing for this 25 CTRL+ Y, so repeat the last action. So very important function again is CTRL+Z (undo), the last edit, so if I have, let us say, edited these in blue and if I want to undo it, what can I do? I can actually use this from the top, which undoes font or undo button. So I can press these, or I can use the Microsoft Excel shortcuts, which is CTRL+Z.CTRL+Z if I do for the first time, the most recent will get undone if I press CTRL+Z again, the second last will get undone, and so on and so forth. CTRL+Z is to undo the last edit.Very helpful function, so these are the top 8 Microsoft Excel shortcuts for working with the data. I hope you remember these. Here we will learn the top 3 formulae of Microsoft Excel shortcuts; one is if I want to write the formula, I can actually go at the top and start Insert function, so I can do that and equals to sign by default, so this is how a formula can be written in a traditional way. However, if I want to begin a formula, I can just type equals to and start typing the formula. So though many of you may use it by default, but it is again a very important Microsoft Excel shortcut. The other thing is, let us say If I want to cancel an entry which I am making in the cell, say, for example, I am writing something like this formula shortcuts, and I have not yet pressed ENTER, and I want to cancel an entry. I do not want to write this. So there are two approaches, first ENTER and go back and delete it, or let us say if I am writing this formula shortcut and if I have not yet pressed ENTER, I can actually press ESCAPE button ESC at the top left-hand corner of your keyboard ESCAPE. So whatever I have made the entry that will go away, so it is a very useful function. The second function here is ALT and equals to. So insert a sum auto sum formula so it’s very, again, very-very useful. Let us say we I want to sum total this series here 4, 5, 6, 3. Now I have I can do this in a very traditional way. I can actually use go at the top and choose the auto sum, OK. So moment I do this, the formula bar will come, and I just need to press ENTER, and the sum total will be 18. The second approach will be, I can go back and press equals to, and a sum bracket open and choose this range and close the bracket, so again, the sum total will be 18, or the third approach, which is more effective, is choosing the ALT = ‘ sign, so ‘ALT=’ sign would mean doing an auto sum in much more efficient way. I don’t really have to use mouse to click at auto sum. I can immediately do that using my keyboard. So very efficient function here, so overall, if you look at this set of video series, we have learned around 44 most important basic Microsoft Excel shortcuts. I hope you will try to make the best out of this all the very best.
Recommended courses
This article has been a guide to Microsoft Excel shortcuts to save time. The idea here is to access data easily. This post is a complete heads-up on Microsoft Excel shortcut keys. These are the following external link related to Excel, so go through the links for more details: