How To Add/Delete A Sheet

This post shows three distinct methods to add a new sheet into a Google Sheet and steps to delete a sheet.


Using Sheets Tab Bar

  1. Open your Google Sheet.

  2. Locate the “+” icon at the bottom left corner of the spreadsheet.

  3. Click on the “+” icon to add a new sheet.

  4. A new sheet will be added with a name in “Sheet<number>” format.

Add Sheet Plus Icon
 

Via Menu Bar

  1. Open your Google Sheet.

  2. On the menu bar, click on the “Insert” menu and then the “Sheet” menu item.

  3. A new sheet will be added with a name in “Sheet<number>” format.

New Sheet From Menu
 

Using Keyboard Shortcuts

  1. Open your Google Sheet.

  2. Press Shift + F11 (Windows) or Shift + Fn + F11 (Mac) on your keyboard.

  3. A new sheet will be added with a name in “Sheet<number>” format.

The following animation demonstrates all the above three methods to add a new sheet.

New Sheet Animation
 

Delete A Sheet

  1. Open your Google Sheets.

  2. Right-click on the sheet tab (at the bottom of the screen) that you want to delete.

  3. From the context menu, click on the “Delete” menu-item.

  4. A confirmation dialog will be displayed.

  5. Click the "OK" button to confirm the deletion of the sheet.

  6. The sheet is now successfully deleted.

The following animation demonstrates the above steps.

Previous
Previous

How To Create Dropdown From Existing Data

Next
Next

How To Create A Dropdown List