How to Open New Sheet in Excel (7 Quick Methods)

Working on more than one sheet is a very common practice for excel users. There are multiple options to open a new sheet in excel. In this article, we will discuss how to open a new sheet in excel with 7 quick methods.


Download Workbook

Get the sample file here to practice by yourself.


7 Quick Methods to Open New Sheet in Excel

For illustration, here is a dataset with the information of a half yearly profit report of a company in 2020. The workbook has only one worksheet named 2020.

How to Open New Sheet in Excel


Now we will open a new sheet in this workbook with the methods below:

1. Open New Sheet Using Keyboard Shortcuts

The use of keyboard shortcuts is one of the easiest methods to open a new sheet in excel. Let’s see the quick steps below:

  • First, press Alt + Shift + F1 on your keyboard.
  • Otherwise, press Shift + F11 on the keyboard.
  • After this, you will see that a new sheet appeared beside the old one.

Open New Sheet Using Keyboard Shortcuts

  • Release the keys from your keyboard.
  • In case of multiple sheets, press Ctrl + Shift + PgDn to insert sheets to the right.
  • Otherwise, press Ctrl + Shift + PgUp to move the sheets left.
  • Now, press Shift + F11 to make new sheets in excel.

Open New Sheet Using Keyboard Shortcuts


2. Apply New Sheet Tool in Excel for Opening Worksheet

Another easy way is to apply the New sheet tool for opening a new worksheet. Follow the below steps:

  • In the workbook, click on the first sheet.
  • Now, press on the New Sheet icon or the Plus (+) icon.

Apply New Sheet Tool in Excel for Opening Worksheet

  • You will see another worksheet with it.

Read More: How to Create New Sheets for Each Row in Excel (4 Quick Ways)


3. Get New Sheet with Insert Dialogue Box

At this stage, we will see the process to open a new sheet with the Insert dialogue box. To do that:

  • First, right-click on the first sheet.
  • Then, select Insert from the Context Menu.

Get New Sheet with Insert Dialogue Box

  • After that, select Worksheet.
  • Then, press OK.

Get New Sheet with Insert Dialogue Box

  • Finally, you will see a new sheet with the previous one.

Read More: How to Insert Sheet from Another File in Excel (3 Easy Ways)


4. Use Excel Home Tab to Open New Sheet

Another easy option for opening a new sheet is to use the Home tab. Let’s see how it works.

  • First, go to the Home tab and select Insert under the Cells group.

Use Excel Home Tab to Open New Sheet

  • Then, choose Insert Sheet from its drop-down menu.

Use Excel Home Tab to Open New Sheet

  • Finally,  you will see a new sheet has been added successfully.

Read More: How to Create Multiple Worksheets from a List of Cell Values


5. Open New Sheet by Creating a Copy

If you want the new sheet as the same as the existing one, then follow the steps below:

  • First, right-click on the first worksheet.
  • Then, select Move or Copy.

Open New Sheet by Creating a Copy

  • After this, mark the Create a copy checked.
  • Then, press OK.

Open New Sheet by Creating a Copy

  • That’s it, you will have your new worksheet.


6. Insert Multiple Sheets with Excel VBA

In this section, we will discuss the process of inserting sheets with Excel VBA. Following is the process:

  • First, go to the Developer tab and select Visual Basic.

Insert Multiple Sheets with Excel VBA

  • Now, choose Immediate Window from the View section.

Insert Multiple Sheets with Excel VBA

  • After that, insert this code on the blank page.

Insert Multiple Sheets with Excel VBA

  • Finally, you will see that 5 new sheets are added to the workbook as we insert the required number of sheets as 5.

Read More: How to Create Multiple Sheets with Same Format in Excel (4 Ways)


7. Create Default Number of New Sheets in Excel Workbook

In this last method, we will create a new excel workbook with default worksheet numbers. This process is applicable if you are clear about the required sheet number. Let’s see the process below:

  • In the beginning, go to the File tab.

Create Default Number of New Sheets in Excel Workbook

  • Then, select Option from the menu.

Create Default Number of New Sheets in Excel Workbook

  • Now, in the Excel Options dialogue box, select General.
  • Then, insert the number of pages on the Include this many sheets box.

Create Default Number of New Sheets in Excel Workbook

  • Finally, press OK and you will get a new workbook with the required number of worksheets.

Read More: How to Create Multiple Sheets in Excel at Once (3 Quick Ways)


How to Format New Sheet in Excel

Here are some quick tips to format the new sheet in excel.

1. Change New Sheet Name

You can change the sheet name following this process:

  • To change the sheet name, right-click on it and select Rename.

How to Format New Sheet in Excel

  • Then, change the name as you require.

Read More: How to Create Multiple Sheets in Excel with Different Names


2. Change Color of Tab

Check the process below to change the color of the new tab:

  • First, right-click on the worksheet.
  • Then, select Tab Color.

How to Format New Sheet in Excel

  • Here you will get numerous options of colors. Choose one from there.


3. Change Position of Worksheet

When you left-click on the new sheet by pressing the Ctrl button on your keyboard, it will show this icon (see screenshot). It benefits to drag the sheet anywhere you want.


How to Delete Sheet in Excel

There are two ways to delete a worksheet in excel. Let’s check them below:

  • Firstly, right-click on the sheet and click Delete.

How to Delete Sheet in Excel

  • Otherwise, go to the Home tab and choose Delete Sheet from the Delete option.

How to Delete Sheet in Excel


Things to Remember

  • You can add up to 255 new worksheets in excel.
  • The more sheets you insert, the more your workbook operation may slow down. So it is better not to compile too many sheets at once.
  • It is a good practice to Group multiple sheets when you need to delete them.
  • Instead of Delete, you can Hide the worksheet. After completing work, you can Unhide them as well.


Conclusion

Henceforth, I hope that it was a helpful article for you on how to open a new sheet in excel with 7 quick methods. Let us know if you have any other methods for this. Follow ExcelDemy for other excel blogs.


Related Articles

Guria

Guria

Hello! Welcome to my blog. I have completed my Bachelor in Architecture from Ashanullah University of Science & Technology, Dhaka. I am a passionate, goal-oriented person with an immense thirst for knowledge and an attitude to grow continuously. Besides Architectural work, I find it very enthusiastic to work in Excel blogging. Exceldemy is a platform where I have got the opportunity to flourish my skill in Microsoft Excel and therefore, here I will be posting blogs related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo