GCFLearnFree.org

As a website designer, I can say you have one of the best learning websites.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Google Sheets
  • Working with Multiple Sheets

Google Sheets

Single page view print copy

Working with Multiple Sheets

To move a sheet:

  1. Click, hold, and drag the tab of the sheet you wish to move. As you move the tab, a vertical blue bar  will appear to indicate where the tab will be placed.
    Screenshot of Google SpreadsheetsMoving a sheet tab
  2. Release the mouse to place the tab at the desired location.
    Screenshot of Google SpreadsheetsAfter placing the tab

To duplicate a sheet:

  1. Click the tab of the sheet you wish to duplicate, then select Duplicate from the menu that appears.
    Screenshot of Google SpreadsheetsSelecting 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 April". If you want, you can rename the sheet.
    Screenshot of Google SpreadsheetsThe duplicated sheet

To copy a sheet to another spreadsheet in Google Drive, click the tab of the sheet you want to copy, and 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 wish to delete. Select Delete from the menu that appears.
    Screenshot of Google SpreadsheetsSelecting Delete
  2. A warning dialog box appears. Click OK.
    Screenshot of Google SpreadsheetsClicking OK
  3. The sheet is deleted.
    Screenshot of Google SpreadsheetsThe remaining sheet tabs

 

previous next
previous 1 2 3 4 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.