Creating a Workbook with Multiple Worksheets

Learning Objectives

  • Create a new workbook with more than one worksheet.

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