How do I copy a worksheet in numbers and retain all the page formatting and formulas but not the data entered in the cells?

Question

Level 1

4 points

How do I copy a worksheet in numbers and retain all the page formatting and formulas but not the data entered in the cells?

I tried the "Duplicate" option and the page (tab) duplicates but all of the entered data remains. Is there a way to wipe out all the data in one fell swoop instead of deleting the data one cell at a time and still keep all the formatting and formulas?

Thanks......

Posted on Jan 1, 2025 3:10 PM

Reply

Answer 1

SGIII

Level 8

37,550 points

Jan 4, 2025 4:54 AM in response to kemaba

On a backup of your document try selecting all the cells in a table and running this shortcut. (Click the link in Safari to view it).

https://www.icloud.com/shortcuts/bd2781f9e8ba408fa13fc622e64c4517

After clearing out the data but leaving the formulas then Duplicate the sheet.

SG

Reply

Answer 2

Yellowbox

Level 7

21,939 points

Jan 4, 2025 6:36 PM in response to kemaba

Hi kemaba

Just a thought. Enter your input data in one table and keep your formulas in a separate table on the same Sheet. Duplicate the Sheet. Delete the data in the Input table, without affecting the formulas.

More information on your overall aim may lead to a solution!

Regards,

Ian.

Reply

How do I copy a worksheet in numbers and retain all the page formatting and formulas but not the data entered in the cells?

Similar questions