Add worksheet with mouse clicks
To add a new worksheet, you need to first create a new Excel workbook. You can also open an existing Excel file on your computer.
For our example, let’s create a new blank workbook.
By creating a new blank workbook, a new blank worksheet is seen on your screen 👇
If you want to see your worksheets, just look at the Sheets Tab at the bottom left of your Excel window👀umn.
Let’s add another Excel sheet to our new workbook.
All you have to do is to click the plus icon (+) next to Sheet 1.
And that’s it! You will be automatically directed to the new worksheet you can work on 😊
Simply click the plus icon if you want to add more worksheets to the workbook. The sheet name will follow as Sheets 1, 2, 3, and so on. The newly added worksheet will be the rightmost sheet in your Excel sheet tab.
One new sheet in one click 👍
Add worksheet using right-click menu option
Alternatively, you can also insert a new worksheet using the right-click menu option. Here’s how to do that 👇
- Right-click on the Sheet2 tab.
- Select Insert.
The Insert dialog box will appear. It will show you what you can insert.
- Click Worksheet.
- Finally, click OK.
The new worksheet will be inserted before the selected sheet tab. In our case, between Sheets 1 and 2.
You might be saying: “This isn’t in order.” 🤔 and you’re right.
But you don’t need to worry. You can move a sheet tab to where you want it to be.
Move your worksheet
To move an Excel worksheet, you just need to press on that sheet tab and drag.
Alternatively, you can also right-click on the sheet tab to find the Move or Copy option to move or copy the worksheet 😊