totn Excel 2016 Basics

MS Excel 2016: Insert a sheet

This Excel tutorial explains how to insert a sheet in Excel 2016 (with screenshots and step-by-step instructions).

Question: How do I insert a new sheet in Microsoft Excel 2016?

Answer: When you create a new document in Excel 2016, your spreadsheet will be created with only one worksheet called Sheet1. You can easily add more sheets as you need them.

You can view all of the sheet names as tabs along the bottom of the document. To add a new sheet, simply click on the plus button Microsoft Excel to the right of the sheet names (we have circled this button on the image below). When you click on this plus button, it will insert a new sheet to the right of the current sheet.

Microsoft Excel

Now when you return to your spreadsheet, a new sheet should be inserted and you will be positioned on cell A1 within this new sheet. In this example, Sheet2 has been inserted into the spreadsheet. Excel will always name its sheets as Sheet1, Sheet2, Sheet3, and so on.

Microsoft Excel