How to Insert a Worksheet

The worksheets in an Excel file can hold different information, but many times people like to have similar information in one workbook and put different topics in different worksheets. Depending on your preference, there are a couple of ways to insert a worksheet.

Method 1: Worksheet Plus sign

The easy way to insert a worksheet is to click the plus sign after the worksheet name.

Method 2: Right-click to open the dialog box

Step 1: Right-click on the tab name, and select "Insert" from the list in the dialog box;

Step 2: In the "Insert" dialog box, click "Worksheet";

Step 3: Click "OK" at the bottom.

Method 3: Commands from the Ribbon

Step 1: Click any cell in the current worksheet;

Step 2: Click the "Home" Tab from Ribbon;

Step 3: Click "Insert" in the "Cells" section, and select "Insert Sheet" from the drop down list.

Leave a Reply

72 Excel Shortcuts 
Print Version 
FOR FREE!!

Download this free Excel Shortcuts Cheat Sheet print version to save your time in your daily work!
Yes, I want it!
Subscribe to receive more excellent notes for free!
close-link