See all How-To Articles

How to Add Multiple Worksheets to Excel & Google Sheets

This tutorial demonstrates how to add multiple worksheets to Excel and Google Sheets.

 

add multiple sheets 3

 

Add Multiple Worksheets

In Excel, there are several ways to add multiple worksheets at once to your workbook. You can go through the Ribbon, right-click, use a shortcut, or write VBA code. Except for VBA, all of these methods require you to have more than one sheet in your workbook to start. You can add as many sheets at a time as you already have in the workbook. For example, if you have two sheets, you’ll be able to add a maximum of two more sheets at once.

Insert Sheets Through Excel Ribbon

To use this method, hold the SHIFT key and select the number of sheets you want to insert. In the Ribbon, go to Home > Insert > Insert Sheet.

 

add multiple sheets 1

 

As a result, two new sheets are added to the workbook. Two was the maximum number of sheets you could add in this case, because there were only two existing sheets.

 

add multiple sheets 2

 

Right-Click to Insert Sheets

You can also use the context menu (right-click) to add new sheets.

  1. First, hold the SHIFT key and select the number of sheets you want to add, and right-click any tab. From the list, choose Insert.

 

add multiple sheets 7

 

  1. In the Insert window, choose Worksheet, and press OK.

 

add multiple sheets 5

 

As a result, new sheets are added.

 

add multiple sheets 8

 

Shortcuts – Insert Sheets

To add multiple worksheets using the keyboard, first, hold the SHIFT key and select the number of sheets you want to add. With the sheets selected, press ALT + SHIFT + F1, or you can use SHIFT + F11.

Use either shortcut multiple times to quickly add more sheets (without needing a certain number of existing sheets).

Add Worksheets – Google Sheets

Unfortunately, in Google Sheets, there is no way to add multiple sheets at once; you have to add them one by one.