- 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:
- A workbook with monthly sales figure with each year on a different worksheet
- A workbook with mailing lists for weekly flyers on one worksheet and coupon mailings on another
- 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.
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.
You can also use the menu option Insert>Insert Sheet from the Cells group of the ribbon.
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.