Excel workbooks are made up of many parts. Sheets contain columns and rows. Cells are the intersection of rows and columns. With all of these groupings, your workbook has plenty of space to capture and analyze your data.
Your Excel workbook is sure to evolve over time. It helps to know how to insert sheets in Excel. This gives you new “spaces” to work with your data. Let’s learn how to insert sheets in Excel.
How to Insert a Sheet in Excel
First, you might already know that each sheet is a tab at the bottom of your Excel workbook. In Excel, you’re always working with one sheet at a time in the active area. To switch sheets, click on a different tab and Excel will change the view.
The easiest way to insert a new sheet is to click on the + button at the end. You’ll see a new sheet added to the workbook. Double-click on the sheet name, then type in a new name to clearly label it.
That’s all there is to it. If you need to re-sequence your sheets, just click and drag-and-drop the worksheet to another position.
How to Insert Multiple Sheets in Excel
Let’s say that you have a vision for how your workbook should come together. It involves many sheets, and you don’t want to have to insert new sheets one-by-one. It helps to insert multiple sheets in Excel with this helpful shortcut.
Let’s start by deciding how many sheets to insert. For my example, I want to add three more. Start by clicking on a sheet tab, holding shift, and click on a sheet that is two tabs to the right. That gives you three selected sheets.
Now, right-click and choose Insert. You’ll add as many new sheets as you selected in the prior step. See the screenshot below as an example.
That’s it! Whether you’re adding one sheet or many, follow these steps to grow your workbook.