How to Add Multiple Sheet in Google Sheets

Author: Iqbal | Guide: Google Sheets |

Google Sheets is a free spreadsheet application that can be used to store, retrieve and manipulate spreadsheet data. It is very easy to insert sheet in a Google spreadsheet. You can create numerous sheets to better organize your spreadsheet and make it easier to find information while working with a huge volume of data.

When you make a new Google spreadsheet, it comes with only one sheet, which is named Sheet1. You'll find a tab for each sheet you have in the sheets toolbar at the bottom of the window. You may create, rename, delete, relocate, and duplicate sheets to organize your spreadsheet and make it easier to explore. In this article, we will tell you how to add sheet in google sheets.

How to merge multiple Google Sheets into a single (Master) Sheet

Add Multiple Sheet in Google Sheets in 2 Steps

Step 1 - Open the google sheets app: Before we go into the specifics of adding sheets in Google Sheets, you need to have the application of google sheets installed on your device.

  • Look for the green-colored icon in the shape of an A4 size paper.
  • It has white outlined cells over it. If are unable to find it, go to the play store and search for 'google sheets' in the search bar, and install the application.
  • Google sheets is a great tool for data tracking.
  • It’s lightweight, affordable, and has an intuitive interface that makes it simple to use.

image titled Insert Sheet step 1

Step 2 - Click on the + icon: It is very easy to add new sheet in Google sheets. Whenever you need to open another sheet in the spreadsheet, just locate the  "+". You will find it in the bottom right corner or the left corner based on the application version.

  • Just tap on the + symbol to add a new sheet.
  • The name of the new sheet will be "Sheet" followed by a number one more than the number of sheets present before you made that new sheet.
  • You can right-click on this sheet to change the name of the sheet, you can hide this sheet if you wish to. You can also change the colour of the sheet.

image titled Insert Sheet step 2

Conclusion

In conclusion, adding a new sheet to the spreadsheet is a one-click task that is very easy, to say the least. One spreadsheet is never enough in this Data Age. When you might have the most significant pieces in the other sheet, no one wants to scroll and scroll to look at one particular entry in the sheets.

The length of the data, as well as other considerations, necessitate the addition of more sheets to the spreadsheet. It increases efficiency, and your work becomes, to put it mildly, simple and stress-free.

When working with a large amount of data, you can create multiple sheets to better organise your spreadsheet. It makes it easier to discover information.

Was this article helpful ?

No