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.