When using Create Worksheet Copy, common questions usually focus on copied content, naming rules, and where the duplicate appears; this FAQ covers 4 common questions.
FAQ
Does the copied worksheet keep the original formatting and formulas?
- Yes. The copied worksheet keeps the original content, formatting, formulas, and conditional formatting.
- After the copy is created, open the duplicate and check key cells, formula areas, and formatting styles.
- If you want to make a new version, edit the duplicate directly.
Do the copied worksheet and the original worksheet stay synced?
- No. They do not stay synced.
- After the copy is created, the original worksheet and the duplicate exist as two separate worksheets.
- Changes in one sheet do not update the other automatically.
Where does the copied worksheet appear after it is created?
- The copied worksheet is added automatically to the worksheet tab list.
- The new duplicate usually appears after the worksheet that was copied.
- If the file has many worksheets, swipe across the bottom tab area to find the new sheet.
How is the copied worksheet named?
- The copied worksheet uses the original name with an added number.
- Common formats include (1), (2), and (3) as sequential suffixes.
- After creation, you can rename the copied worksheet as needed for easier management.
Glossary
| Term | Definition |
|---|---|
| Worksheet | A single sheet inside a spreadsheet file that contains rows, columns, data, and formulas. |
| Worksheet copy | A new worksheet created by duplicating an existing worksheet, with the same initial content as the original. |
| Floating toolbar | A quick action area that appears after you tap a worksheet tab and can include actions such as Copy. |