Excel Shortcut New Sheet (Table of Contents)
Excel Shortcut New Sheet
When we open an Excel file, there we get to see the 3 worksheets which are already there in every new file by default. The sheets are always in the sequence of Sheet1, Sheet2, and Sheet3 respectively or in some cases, there is only one sheet as Sheet1. When we change the name of any of the worksheet and later we add a new worksheet by any method, then the added worksheet would have name as Sheet4. That name would be in sequence to the names and worksheets which were already present there. Even if we delete any worksheet and add a new one, then also the sequence of the selected worksheet would be the same, considering the deleted worksheet into the count. There are different ways to add a new worksheet into an Excel file.
How to Use Excel Shortcut New Sheet?
There are different ways to open a new sheet in the opened Excel file. The generic procedure of adding a new worksheet in Excel is by clicking right on the sheet name tab and selecting the Insert option from the menu list.
The different process of adding new sheets are as below;
- Manual Process
- Through Home menu ribbon
- Through shortcut keys
Examples of Excel Shortcut New Sheet
Lets us discuss the examples of Excel Shortcut New Sheet.
In this example we will see the basic method of adding a new sheet in MS Excel. For this we will open a blank Excel file as shown below. Currently, in our system as per the setting we could only see one worksheet.
Now to add a worksheet in the opened Excel file, click right on the sheet name tab as shown below and select Insert option.
We will then get a box which will ask different files which we want to open and insert. Select Worksheet icon as shown below and click on OK.
A new worksheet will get added in the sequential name of Sheet2 as shown below.
This is another shortcut method to add new sheet in an excel file. For this, again open a excel workbook and there is section at the bottom left which has the sheet names along with a PLUS option as shown below.
Now click on that PLUS button.
This will simply add a new worksheet as per the current naming sequence or previously added file names. Here, we already had Sheet1 and Sheet2, so we would get Sheet3 as shown below.
If we change the name of worksheet into different names and again we try to add new sheets then we will see the new worksheet will be added with same default name. For testing, we have change the names of the sheets as Test1, Test2 and Test3 as shown below. Now click on the PLUS tab and see the name of worksheet which will get added.
We will see, the newly added sheet name is by default named as Sheet4, in the sequence of number of sheet which we added recently.
To add a new worksheet in an Excel file, we have a shortcut key, which would simply add a new worksheet into opened excel file. To insert a new sheet using shortcut key press SHIFT + F11 together. This would add a new sheet in the sequential name of worksheets which are already opened.
We have seen most of the possible ways to add new sheet in Excel. But every function or operations which we could be performed by shortcut keys and right click menu list, could also be performed by using the options available in Menu ribbon tab. To insert a new sheet using menu option first go to Home menu ribbon and under the cells section we have Insert option under same Home menu ribbon as shown below.
From the dropdown menu list of Insert option, we select Insert Sheet as shown below.
Once we select this Insert Sheet option, a new worksheet will get added as shown below in the name of Sheet6.
There is another way to add a new worksheet. For this, press and hold CTRL key and drag any added worksheet as shown below.
Once we release the CTRL key the selected sheet will get copied along with data with duplicate name of the same as shown below.
Pros Of Excel Shortcut New Sheet
- All the methods and procedures shown in above examples are simple to execute.
- There is no limit on restrictions on adding new worksheet by any method.
- We can change the setting to see the default sheet names and default sheets count when we open a worksheet or a workbook.
Things To Remember
- Mostly the sheet name is in the sequential count as per the sheet added previously.
- If we delete any worksheet and add a new one after that, then newly added worksheet number sequence will be as per the deleted worksheet, not with respect to available worksheet. For example, we have 3 worksheets and we delete 3rd Adding a new worksheet after that, will be named as Sheet4.
- We can even change the default name of any worksheet from Sheet1 to any other name.
- Dragging the already existed sheet, will create the new copy of the same worksheet with data available under it.
This has been a guide to Excel Shortcut New Sheet. Here we discuss How to Excel Shortcut New Sheet along with practical examples. You can also go through our other suggested articles –