Creating a Workbook with Multiple Worksheets | Computer Applications for Managers

Module 6: Microsoft Excel Basic Skills

Creating a Workbook with Multiple Worksheets

Learning Outcomes

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

<br />

<br />

Contribute!

Did you have an idea for improving this content? We’d love your input.

Improve this page Learn More