Docs Help

While it's not possible to create templates for an entire spreadsheet, it is possible to create template sheets within a spreadsheet.

To do this, you enter and format data in one sheet of a spreadsheet; this data then serves as a template when you copy the sheet.

To copy one sheet of a spreadsheet and effectively create a template, follow these steps:

1. On the bottom-left side of your spreadsheet, click the tab of the sheet you'd like to copy (i.e. "Sheet1").
2. Select "Duplicate" from the pop-up menu.

A duplicate sheet (which contains the exact formatting) now appears in a tab beside the original sheet.