Working with Multiple Sheets

In Google Sheets multiple sheets can be created and used simultaneously. Learn all about using these sheets here.

To move a sheet:

  1. Click and drag the tab of the sheet you want to move.
    Moving a sheet tab


  2. Release the mouse to place the tab at the desired location.
    After placing the tab

To duplicate a sheet:

  1. Click the tab of the sheet you want to duplicate, then select Duplicate from the menu that appears.
    Selecting Duplicate
  2. A duplicate of the sheet will appear in the sheets toolbar. It will be named as a copy of the original sheet, such as Copy of May. If you want, you can rename the sheet.The duplicated sheet

To copy a sheet to another spreadsheet in Google Drive, click the tab of the sheet you want to copy, then select Copy to... from the menu that appears. Select the spreadsheet where you want to place the copy from the list that appears. A duplicate of the sheet will appear in the other spreadsheet.

To delete a sheet:

  1. Click the tab of the sheet you want to delete. Select Delete from the menu that appears.
    Selecting Delete
  2. A warning dialog box appears. Click OK, and the sheet will be deleted.
    Clicking OK

Challenge!

  1. Open our example file. Make sure you're signed in to Google, then click File > Make a copy.
  2. Delete the sheet titled Sheet 1.
  3. Duplicate the January sheet and rename it May.
  4. Move the sheet you just renamed to the right of the April 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:
    multiple sheets challenge example