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 insert 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 infact I use this microsoft excel shortcuts 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 and 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 o.k. 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 shortcuts 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 top8 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 shortcuts. 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 shortcuts 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 autosum formula so its 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 chose the auto sum O.K. 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 autosum I can immediately do that using my keyboard. So very efficient function here, so overall, if you looked 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.
This has been a guide to the Microsoft Excel shortcuts to save time. The idea here is to access data easily. This post is a complete heads-up on Microsoft Excel shortcuts keys. These are the following external link related to Excel so go through the links for more details: