Insert New Worksheet in Excel (Table of Contents)
- Insert New Worksheet in Excel
- Modify Default Number of Worksheets
- Insert New Worksheet in Existing Workbook
Insert New Worksheet in Excel
When you open an excel workbook how many worksheets can you see? Maybe you have not realized how many you see by default.
If there are no modifications in settings by default excel will give you 3 worksheets named Sheet 1, Sheet 2, and Sheet3 as shown in the below image.
In this article I will show you ways of adding new worksheets in excel, how to modify the number of worksheets when you open new excel workbook, how to change the color, theme etc… in this article.
Open New Workbook from your Computer
Let me start with opening a new workbook in excel. For this article, I am using Excel 2010 and operating windows is Windows 10.
Step 1: In the search box of your computer type excel, it will show you excel app in your computer.
Step 2: Click on the Excel version app on your computer.
4.8 (1,665 ratings)
Step 3: If any of the workbooks are already open, you will directly see a new workbook and a total of 3 worksheets.
Now we will see how to modify the number of worksheets by default.
Modify Default Number of Worksheets
Now we have seen default excel can give us 3 worksheets in the new workbook. However, if you are not satisfied with the number of worksheets, in the first go itself excel offers you to modify a number of worksheets as per your wish. Follow below steps to modify your excel settings.
Step 1: Go to FILE.
Step 2: Under FILE go to OPTIONS.
Step 3: Select GENERAL Excel Options and select Include this many sheets. Here you can insert up to 255 worksheets when the new workbook is inserted. It is highly unlikely we use 255 worksheets. I have limited my worksheets to 6.
Step 4: Click on Ok to complete the process.
Step 5: Now open a new workbook and see the magic.
The shortcut key is Ctrl + N to open a new workbook when at least one excel workbook is already open.
I have 6 worksheets instead of regular 3 worksheets when the new workbook is inserted. This modification is applicable for all the workbooks going forward.
Insert New Worksheet in Existing Workbook
Now we have learned how to modify the number of worksheets when we open a new workbook. Now we will concentrate on ways of inserting a new worksheet in the existing workbook.
Assume you are working in a workbook and you have 3 worksheets already. Now you have to insert one more worksheet for the new month sales, you can insert new worksheet manually as well as by using shortcut key as well.
Insert New Worksheet in Excel Manually – Method 1
Step 1: Right-click on any of the worksheet.
Step 2: Select the insert option and you will see below the window. Select Worksheet as the option.
Step 3: Since I have right clicked on the worksheet Mar now I have a worksheet on the left of the Mar worksheet.
Step 4: Now you can rename this worksheet by double-clicking on the sheet name.
Insert Worksheet Manually – Method 2
If you think the previous step was a bit lengthy and time to consume you can choose this one. This is as easy as you like.
After all the worksheet you will see Plus (+) icon.
Click on this plus icon to insert a new sheet. This will insert the worksheet to the right of the active worksheet.
Insert Worksheet Manually – Method 3
We have one more way of creating new worksheet manually. This is also a simple one but of a manual process.
Go to the HOME tab and Find Insert button under the HOME tab.
Now select Insert Sheet option.
This will insert the new worksheet to the left of the active worksheet.
Using Shortcut Key – Method 4
We can also Insert New Worksheet in Excel by using the shortcut key Shift + F11
Enough of manual methods in excel to Insert New Worksheet in the existing workbook. Yes, the manual process is a frustrating one and that is why we have the short cut key to insert very quickly.
Press the keys Shift + F11 key together it will insert new worksheet to the left of the active worksheet.
Create a Copy of Existing Worksheet as New Worksheet
If you are working in the worksheet and you need a replica of the worksheet you are working on, you can create a replica of the sheet as well.
Assume your current worksheet name is Mar. Hold Ctrl key and drag the worksheet to the right side you will have a replica of the worksheet.
Things to Remember About Insert New Worksheet in Excel
- In order to insert multiple sheets once, you need to select those sheets which you want to insert and click the shortcut key.
- Insert New Worksheet in excel is a feature that automatically adjusts the width or height of a cell.
- To rename the worksheet double click on the sheet name and type the new name.
- All the method insert the new worksheet to the left of the active worksheet excel clicking on Plus icon button.
This has been a guide to Insert New Worksheet in Excel. The easiest way to adjust a column is to use the Insert New Worksheet in Excel. Here we discuss how to use Insert New Worksheet in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –