How to create multiple sheets in Google Sheets?

Last updated Jul 09, 2022

You can create multiple sheets and work on them using Google Sheets simultaneously. This article will explain to you how you can do so.

When you open a new spreadsheet, Google Sheets opens a single sheet by default. Nonetheless, you are not limited to opening single sheets in a single spreadsheet. The sheets toolbar at the bottom of the window has a tab where you can see the sheet you have. Here you can organize, rename, delete, and duplicate sheets in your spreadsheet to make it easier to navigate, rename, and delete them. Now let's see how you can open multiple sheets on one spreadsheet.

 

How to create multiple sheets in Google Sheets

Step 1: Open a new or an existing spreadsheet

How to create multiple sheets in Google Sheets

 

Step 2: Navigate to the bottom of your spreadsheet, where you will see an "Add Sheet" command.

How to create multiple sheets in Google Sheets2

 

Step 3: Click on the "Add Sheet" command, and instantly, a new sheet will appear and will be named sheet two.

How to create multiple sheets in Google Sheets3

 

Step 4: Now, repeat step 3 until you open the number of sheets you would like to work with.

How to create multiple sheets in Google Sheets4

 

Conclusion

As a result, you can create any number of sheets on your spreadsheet using the "Add Sheet" command. These sheets can be edited, shared, deleted, and saved as normal sheets

Article Contributed By :
https://www.rrtutors.com/site_assets/profile/assets/img/avataaars.svg

57 Views