Creating a Workbook with Multiple Worksheets

Learning Objectives

  • Create a new workbook with more than one worksheet.

When you open a new Excel file, there is automatically a single worksheet. However, there are a number of reasons why you may want more than one worksheet in a single workbook. For example, consider the following ways multiple worksheets in a workbook can help with keeping data organized:

  1. A workbook with monthly sales figure with each year on a different worksheet
  2. A workbook with mailing lists for weekly flyers on one worksheet and coupon mailings on another
  3. A workbook with inventory data with each month on a different worksheet

In any of these cases, or others, it is very easy to add more worksheets to an Excel workbook.

Method 1

The easiest method to add additional worksheets to a workbook is by using the Insert Worksheet shortcut represented by the + button at the bottom of the workbook window. You can use this shortcut button multiple times to insert additional worksheets into your workbook.

A blank excel sheet is open. A green arrow is pointing at the option to add a new sheet.

Method 2

You can also use the menu option Insert>Insert Sheet from the Cells group of the ribbon.

A blank excel sheet is open. There is a green arrow pointing to the insert dropdown menu, and specifically the insert sheet option.

Practice Questions

 

Practice Questions

Check Your Understanding

Answer the question(s) below to see how well you understand the topics covered in the previous section. This short quiz does not count toward your grade in the class, and you can retake it an unlimited number of times.

Use this quiz to check your understanding and decide whether to (1) study the previous section further or (2) move on to the next section.