Copying an existing sheet boosts your productivity by letting you avoid manually setting up columns and automation, so you can focus immediately on data entry and execution.
USM Content
If you only have Viewer permissions, you can't carry over specific automation rules or sharing settings, depending on the workspace restrictions.
There are two main ways in which you can duplicate a sheet: From the workspace panel or via the sheet's Save as New… option.
Duplicate a sheet (or other item) from the workspace panel
Copy sheets and other items from any workspace without opening them one by one.
To duplicate an item, you need at least Editor—can share permissions.
- Open your workspace to access the workspace panel on the left. Hover over the item (sheet, report, or dashboard) you wish to duplicate.
- Right-click the item, or use the
three-dot menu, and select Duplicate.
- A Duplicate item window opens where you can:
- Rename the item.
- Decide where to save it. You can place the duplicated item in the current workspace or choose a different one.
Keep in mind that you can’t customize the sharing option.
- Select Duplicate.
Duplicate a sheet with Save as New…
From Grid view, you can save a copy of your sheet and customize exactly which components to carry over from the original.
- Select File > Save as New...
- Type a name for the new sheet in the Name your sheet field.
- Use Save in to select the workspace where you’d like to save the copied sheet.
- Display any of the menus: Sharing Options, Automated Workflow & Alert Options, and Data & Formatting Options to select which elements you want to copy to your new sheet.
- Choose Save.
Save as New options
Here are the options available in the Save as New form.
- Sharing Options: Preserve any sheet sharing that you've set up.
- Automated Workflow & Alert Options: Retains any associated automation rules and notifications in the copy of the sheet.
Workflow recipients and Alerts settings: Retains permission settings for the rules.
If a rule for the new sheet has no valid recipients, the sheet owner receives an email notification. The automation rule on your sheet has become invalid, and the sheet’s permissions settings or the approved domain-sharing list are currently preventing recipients from getting notifications.
To modify rule permission settings for the sheet:
- Select Automation > Manage automation workflows... on the menu bar
- In the Saved Automation Workflows window, select the Settings
icon in the upper right to modify automation permission levels.
- Data & Formatting Options: Retains any associated sheet data and formatting options in the new sheet.
- Sheet data and formatting: Includes information typed into cells and formatting manually applied to them. If unchecked, copied sheets retain column names and types, but all rows are blank.
- Comments: This includes all row and sheet-level comments.
- Attachments: Includes all row and sheet-level attachments.
- Cell links and cross-sheet references: Preserves inbound cell links only. The sheet copy retains the cell data but creates no links if unchecked.
- Sheet hyperlinks: Maintains hyperlinks to other sheets. If you don't check it, the sheet copy retains the cell data but doesn't hyperlink.
- Shared sheet filters: Includes sheet filters.
- Forms: Includes any forms that you add to the sheet.
- Sheet data and formatting: Includes information typed into cells and formatting manually applied to them. If unchecked, copied sheets retain column names and types, but all rows are blank.
Now that you know how to copy sheets and select the components you want efficiently, you can spend less time on sheet setup and more time on the work that matters.