You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

MacBookAir - add sheet to Numbers spreadsheet with same formatting as existing sheets

I use Numbers to track vitals (temp, weight, BP, etc) No calculations. Sheet is full, so I need to add a sheet keeping same format, e.g. column size, headers, etc. How can I do that?

MacBook Air 13″, 12.3

Posted on Mar 29, 2022 12:25 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 29, 2022 9:06 PM

You can go to the sheet name (tab at the top) and choose Duplicate from the dropdown that appears.



That will keep the formatting. It will, of course, also include the data, which you will then need to clear from the new sheet.


If you do this often you can consider keeping an empty sheet with the formatting you want. Then just duplicate it whenever you need to start a new sheet.


If you want to duplicate a sheet to another document you can choose Copy Sheet from the dropdown, go to the destination document, click in the "tab" of and sheet, and choose Paste Sheet.


In general, though, it is best to keep all your data in one table rather than scattering it around your document. A sheet or doesn't get "full." You can add rows to a table as needed.


SG

2 replies
Question marked as Top-ranking reply

Mar 29, 2022 9:06 PM in response to Adagramp

You can go to the sheet name (tab at the top) and choose Duplicate from the dropdown that appears.



That will keep the formatting. It will, of course, also include the data, which you will then need to clear from the new sheet.


If you do this often you can consider keeping an empty sheet with the formatting you want. Then just duplicate it whenever you need to start a new sheet.


If you want to duplicate a sheet to another document you can choose Copy Sheet from the dropdown, go to the destination document, click in the "tab" of and sheet, and choose Paste Sheet.


In general, though, it is best to keep all your data in one table rather than scattering it around your document. A sheet or doesn't get "full." You can add rows to a table as needed.


SG

MacBookAir - add sheet to Numbers spreadsheet with same formatting as existing sheets

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.