Copy a sheet with save as new

Create a copy of a sheet

1. ClickFile>Save as Newto display theSave as Newwindow.
2. Type a name for the new sheet.
3. UnderSave in,select the folder or workspace where you’d like to save the copied sheet.
4. Click to show the options forNotifications & Sharing OptionsandData & Formatting Optionsand choose which items you want to save with the copy of your sheet.
5. ClickSave.

Save as options

• Sharing:Preserves any sheet sharing that you've set up.
• Automated Workflow & Alert Options:Retains any associated Automation rules with the saved copy of the sheet.
• Workflow recipients and Automation Permission Settings:Retains permission settings for the rules.
  • If a rule for the new sheet has no valid recipients (that is, if no one will be able to receive notifications based either on the permission settings or on the approved domain sharing list for the account) the sheet owner will receive this message in email: An Automation rule on your sheet has become invalid. This sheet’s permissions settings are currently preventing recipients from getting notifications.
  • To modify rule permission settings for the sheet:
  1. ClickAutomation > Manage Workflows...on the menu bar
  2. In theAutomationwindow, click theSettingsicon in the upper-right to modify permission levels.
• Sheet data and formatting: Includes information typed into cells and formatting manually applied to them. If unchecked, copied sheets will retain column names and types but all rows will be left blank.
• Comments: Includes all row and sheet-level comments.
• Attachments: Includes all row and sheet-level attachments.
• Cell links: Preservesinboundcell links only. If unchecked, the cell data will be retained in the sheet copy but will no longer be linked.
• Sheet hyperlinks: Maintains hyperlinks to other sheets. If unchecked, the cell data will be retained in the sheet copy, but will no longer be hyperlinked.
• Sheet filters:Includes sheet filters.
• 形式: Includes any forms that have been added to the sheet.