Google spreadsheet supports having multiple sheets in every spreadsheet just like in excel sheets. It is helpful to have different sheets added to the spreadsheet to maintain data for different features during testing. We can have each sheet named accordingly so that it is clearly readable. Let's start by learning how to add a new sheet to a worksheet
Add Sheet
Click on Add Sheet button which is in the bottom left corner of the screen. Once you click on Add, a new sheet is added with the default sheet name and number.
Duplicate Sheet
Sometimes, you may be required to keep the formatting of the sheet the same throughout, rather than formatting every sheet on creating it, just duplicate the sheet to keep the formatting. Delete the unwanted data and you are good to go.
Add Sheet
Click on Add Sheet button which is in the bottom left corner of the screen. Once you click on Add, a new sheet is added with the default sheet name and number.
Duplicate Sheet
Sometimes, you may be required to keep the formatting of the sheet the same throughout, rather than formatting every sheet on creating it, just duplicate the sheet to keep the formatting. Delete the unwanted data and you are good to go.
Insert Tab or Use shortcut Key
You can also insert a new sheet using the Insert tab. Note that you can use SHIFT + F11 to create the new sheet too.
Let me know if there are any other ways to do it. Happy Spreadsheeting :)