How To Add A Tab In Google Spreadsheets

Lesson 11: Working with Multiple Sheets

/en/googlespreadsheets/formatting-cells/content/

Introduction

A Google spreadsheet tin contain one or more sheets. When working with a large corporeality of information, you can create multiple sheets to help organize your spreadsheet and brand it easier to notice information.

In this lesson, you'll acquire how to create, rename, movement, delete, and duplicate sheets.

Using multiple sheets

When you lot create a new Google spreadsheet, it has 1 sheet, which is named Sheet1 by default. In the sheets toolbar located at the bottom of the window, you volition run across a tab for each sheet you have. To organize your spreadsheet and brand it easier to navigate, you can create, rename, delete, move, and duplicate sheets.

Sentry the video beneath to learn how to create and manage multiple sheets.

To create a new sheet:

In our instance, the sheets of our service log are organized past month. We'll create a new sheet in the log and so information can exist entered in the new month.

1. Click the Add Sail command in the sheets toolbar.

   

2. A new sheet will announced in the sheets toolbar.

   

Alternatively, you can create an boosted sheet by clicking Insert and selecting New sheet from the drop-downwards bill of fare.

To rename a sheet:

1. Click the tab of the sail you want to rename. Select Rename... from the card that appears.

   

2. Blazon the desired name for the canvas.

   

3. Click anywhere exterior of the tab or printing Enter on your keyboard when you're finished, and the sheet will be renamed.

   

To switch to a dissimilar sheet:

1. Click the desired sail tab in the sheets toolbar.

   

2. The selected sheet will appear.

If you lot want to limit collaborators from editing specific sheets of your spreadsheet, you can protect these sheets past clicking the desired sheet tab and selecting Protect sheet... from the card that appears.

To move a canvas:

1. Click and drag the tab of the canvas you desire to motion.

   

2. Release the mouse to identify the tab at the desired location.

   

To duplicate a canvas:

1. Click the tab of the sheet you want to duplicate, so select Duplicate from the card that appears.

   

2. A duplicate of the canvas will appear in the sheets toolbar. It will be named as a copy of the original sheet, such every bit Copy of May. If you lot want, you can rename the sheet.

To re-create a sheet to some other spreadsheet in Google Drive, click the tab of the sail you lot desire to copy, so select Copy to... from the carte that appears. Select the spreadsheet where y'all want to place the copy from the list that appears. A duplicate of the sheet will appear in the other spreadsheet.

To delete a canvass:

1. Click the tab of the sheet y'all want to delete. Select Delete from the menu that appears.

   

2. A warning dialog box appears. Click OK, and the sheet will exist deleted.

   

Claiming!

1. Open up our case file. Brand sure you're signed in to Google, and so click File > Make a copy.
2. Delete the canvass titled Sheet 1.
3. Duplicate the January sheet and rename it May.
4. Move the sheet you just renamed to the correct of the Apr sheet.
5. Create a new sheet and rename it June.
6. Open the May sheet.
7. When you're finished, your spreadsheet should look something like this:

   

/en/googlespreadsheets/creating-elementary-formulas/content/

How To Add A Tab In Google Spreadsheets,

Source: https://edu.gcfglobal.org/en/googlespreadsheets/working-with-multiple-sheets/1/

Posted by: jonesbeink1945.blogspot.com

Share this post