• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Insert Sheet in Excel

October 23, 2021 by Andrew Childress
Insert multiple sheets Excel

Your Excel workbook is sure to evolve over time. It helps to know how to insert sheets in Excel. Let's learn how to insert sheets in Excel.

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.

Sheets in Excel

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.

Insert sheet icon

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.

Insert multiple sheets Excel

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.

Insert multiple sheets in Excel

That’s it! Whether you’re adding one sheet or many, follow these steps to grow your workbook.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Review show all comments Excel Clear Comments in Excel
Next Post: Clear Hyperlinks in Excel Hyperlink Menu excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top