Lesson finished
Up next: Introduction to Tableau: Products, Workflow and Data Sources
Unlock all 123 lessons of Medical Data Analytics & VisualizationFull course ₹40,000 · paid
Common Excel Shortcut Keys for Files, Editing and Printing
A free lesson from Skill-Lync's Medical Data Analytics & Visualization course, on Grow by Skill-Lync · Last updated 16 Nov 2026 · Session: “Introduction to Microsoft Excel and Shortcut Keys”
What will you learn in this free Medical Data Analytics & Visualization lesson?
The instructor goes through everyday Excel shortcuts and tries several in the application. These include Ctrl+N, Ctrl+O, Ctrl+S, F12 for Save As, cut, copy and paste, undo, Ctrl+P for the print dialog, selecting a column or row, and the Alt key for keyboard navigation.
- Creating, opening, saving and closing workbooks
- Cut, copy, paste and undo shortcuts
- Opening the print dialog with Ctrl+P
- Using the Alt key for tab shortcuts
What comes after lesson 3?
The next free lesson is lesson 50, “Introduction to Tableau: Products, Workflow and Data Sources” (19 min). Later in Skill-Lync's Medical Data Analytics & Visualization course (paid): lesson 4, Excel Formatting Techniques; lesson 5, Customizing the Quick Access Toolbar in Microsoft Excel; lesson 6, Data Analysis and Visualization using Microsoft Excel. The full course has 123 lessons (54 h 21 min of video); see the course overview or its price and syllabus.
Lesson transcript
Machine transcript of the lesson audio (lightly cleaned). Technical terms may contain errors; the video is the reference.
So till now we have covered, we have understood about how we can launch Microsoft Excel, how we can check the version of installed Microsoft Excel in your system and then we have learned about some basic interface of Microsoft Excel and we have also learned how we can enter the data, how we can edit the data and most wonderfully we have discussed also how to deal with the, how to get advantage of the cell reference whether it is a relative cell reference or it is a absolute cell reference and after that we have common shortcuts with us. So what are the common shortcuts? Shortcut keys are basically functioning to provide you easiest, easiest way to use a particular function. So we have the shortcuts available in that case you are directly moving to a particular functionality rather than following the main path.
you will go with the shortcut. So the first shortcut key we are discussing here, this is control plus N. So what you are pressing here, you are pressing control key and then you are pressing the N from the alphabet key. So this shortcut is used to create a new workbook. So whenever you require a new workbook, rather than going to opening it from file menu, we can do it from control plus N as well. So how we will do it? Let's try it with the Excel also. So I'll launch the Excel the same, the same my favorite way to do that. So what we are doing here in the home. So what we are doing here in the home, I'm going to a blank workbook for example, and I have the option file and to open a new file from new file new. So if I want to do that, I can do it with the choosing the blank workbook or you want to choose any predefined package or any predefined sample template, you can do that. For now we can take the blank workbook as well.
The same thing you can do it by clicking on control plus N. So if I'm here and I'm not going to any file menu and not going to any particular option, what I'm doing, I'm just pressing the control plus N and in that case again, I'm getting the new workbook. How you can get that? You have checked it from the book 3 as well. I'll minimize this. I'll minimize this also. So I'm not saving anything for now. So this is the shortcut control plus N to create a new workbook.
Then the next shortcut key which we are discussing here is control plus O. O is 2 for opening the new workbook or the new, we should not say it new workbook. We should say it the existing workbook that is opening an existing workbook that is control plus O. After that, I have control plus S. This is for the saving, saving the active workbook. So for the opening the existing workbook, what we can use, we can use control plus O. As we have used control plus N to create a new workbook.
Then this control plus S key is used, the shortcut key is used to save the active workbook. F12. F12 is save as. So what is the difference between the save and save as? When you want to change the name of that particular workbook or particular document with any other name, then in that case, you can make it save as. What we can understand it with an example as well. Suppose I have this workbook and what I am doing it, I am saving it. Let's save it with the shortcut only that is control plus C S.
So I am putting the name, I will put it in my desktop. I will name it as maybe week 1. I will put it week 1.1 as the name and I will save this. So this in this way, I have saved that particular workbook here. Now I want to make it the same changes like what I am doing here. I am putting some kind of data here. Some data is available and I am saving it again. Now I will close it and if I will go to my screen or if I will go to my desktop, I can find this particular document over there, which is named as week 1.1.
Now if I want to open the same file, what I can do? I can go to the open and I will look for week 1.1. Now my requirement is to save this same file with another name also. In that case, I will do save as or I can go with the shortcut also and I will put it as a name, maybe second version and save. So I have two files now. One is with the name week 1.1 second version. So I have the same data set with me. So whatever changes I am making in any copy that is independent of the another one.
So basically I have two workbooks but now these two workbooks are carrying the same kind of information but if I want to make any changes, I will make the changes in the open one way. So this time I am working with week 1.1 second version. So I am making the changes in the same file. If I will open the previous one, I will make the changes in the same file. So this is the difference between save and save as. Let's go back to the slide again. So the shortcut key for save as is F12.
We have discussed till now four shortcuts that is common shortcuts. Control plus N is to create a new workbook. Control plus O is to open an existing workbook. Control plus S is to save the active workbook and F12 is to do the save as. Control plus W is used to close the active workbook. So you don't need to go to your interface and close it from the available menu at the top area of the right top area. You can directly do it with the keyboard also that is using control plus W to close the active workbook.
Next shortcut is control plus X or C or V. So you might be aware about this already that control plus C is used to do the copy of the content. Control plus V is used to paste the contents and control plus X is used to cut the content. So I'll write it again. This is cut, copy, paste. So X is for cut, C is for the copy, V is for the paste. So you can use it very frequently. So rather than clicking on the key menu bar in the file, you can go to the keyboard and you can do cut, copy, paste.
Control plus Z is used to do the undo. So if you want to go back to your previous work, you can use the undo. Control plus P is used to open the print dialog. So whenever you're printing, you want to do the printing of your document, what you can do? You can just directly go to the print page, print dialog page that is control plus P. Let's try that. This is very interesting one. So I'll go back to my Excel. So I'll click control plus P.
So it is this print dialog has opened here. Whatever settings I want to do, I can do it from here. If I want to choose my particular printer, yes, I can choose it. I can tell about the active sheets also and the portrait or the landscape orientation you require. Margin you can choose. Scaling you can choose. You can further go for the page setup as well to set up the margins, header, footer and many other functionalities are available. So the another way is to go to file and print.
And otherwise what I can do, I can directly go to control plus P. So both their cases. So normally common shortcuts are used to use these functionalities. So right now we have learned function. This common shortcut for new also. Open also, save also, save as also and for print also. I'll go back to slide. Next shortcut is control plus D. So this is very, very useful shortcut. Whenever you're working with the large data set or even with a good amount of data, whenever you're entering the data, when are you doing the analysis, at that time we use this.
Control plus D is used to copy the content from the above cell. I'll show you. For example, what I'll do, I'll just open my previous file. I'll go back, open so that I save with week one. So this was our previous file where we have learned how we can enter the data, how we can edit the data, how we can do cell reference, whether it is relative or absolute cell reference. So similarly, what I want to do, I want to copy this entire content from this to this row.
So one method is to go to that particular cell, copy it, maybe with the shortcut or you can go with the discard copy and paste thing as well. So what I'll do, I'll paste it. So this is the one way to do that. Otherwise, the second way is to, I am at that particular cell and I want to copy the content from the above cell. So I'll just directly press the control plus D. So I can have that particular value with copying it here. I don't know to go to this control plus C and control plus V.
What I can directly do? I'll just do directly control D. So we can have a good amount of data copying in a single shortcut. Rather than using control plus C and control plus V, I'll directly go with the control plus D. So if I want to copy the entire row, this 500, 15, 20. So I'll try this also. So what I did, I just selected everything and then I press the control plus D. So you just now you think about you have the large data set.
In that case also, you can perform this thing also. Control plus D to copy the content from the above cell. What if, if I try it here, whether it will work? No, it will not work because it is picking the only value that is available at the above position of that particular row. So this is copy the content from above cell. Control plus C space. This is copy the content from above cell. To select the entire column. So, I will try this also. What I want to do, I am here. So, I will do control plus space. So, what I am selecting, I am selecting the entire column here. So, I don't need to go directly here or something like this. Wherever I am here. So, what I will do, I will click on control plus space and what I can do, I can choose the entire column over there. This is the power of the common shortcuts.
Next shortcut is shift plus space. So, select the entire row. So, this is very good difference. So, whenever you want to select the complete row, in that case, what you can do, you can just keep your cell over there. You can put the space accordingly or you can have the path accordingly and then you can click on shift key plus space. When you are doing that, you are selecting the entire row and on the another case, what you are doing, if you want to select the entire column, in that case, you can use the common shortcut key as a control plus space. So, I will go back to my Excel again. So, this shift plus space, entire row selected, control plus space, entire column selected. So, if I am at this cell, then in that case, shift plus space, entire row, control plus space, entire column. So, I can do it like this.
Next shortcut, press Alt key to navigate through keyboard and another thing is that suppose I am here and if you want to move it like another tab, what you can do, you can press the Alt and you can press Alt key and you can actually know about all the shortcut keys that is available with the Excel. So, whatever shortcut you want to use, you can use in the combination, the symbols are written here. So, this P indicates the page layout, formulas for M, A for data, review, view, help and so other ways are to use the common shortcuts.
This is all about using the common shortcut. So, I will revise it again. So, what we have covered till now, we have covered control plus N to create a new workbook. To open an existing workbook, we can use control plus O and to save the active workbook is the workbook in which we are dealing. F12 is to use the save as, control plus W is to close the active workbook and the shortcut is control C, V and X for copy, paste and cut, control Z to do the undo, control P to open the print dialog box and control D to copy the content from above cell.
Ctrl plus space is to select the entire column and shift plus paste to select the entire row and Alt key is to use to navigate through keyboard.