Numbers 14.3 Copy and paste worksheet.

I want to try and start using Numbers I've always used Excel. I'm not an advanced user by any stretch. Most things I search however i'm struggling with this. I want to do a workbook with 12 identical sheets (which I will change late) for each month. But how do I copy and paste keeping all info like row and col height and width, all formats etc.

Thanks

MacBook Air 13″, macOS 15.3

Posted on Mar 5, 2025 3:05 AM

Reply
1 reply
Sort By: 

Mar 5, 2025 7:15 AM in response to daveff

You can duplicate a sheet in Numbers by clicking the sheet "tab" and the top and choosing Duplicate from the dropdown menu that appears. The new sheet will have the same tables and formatting as the original.


However, keep in mind that if in the end you will need to consolidate information from all the monthly sheets then you will find it MUCH more efficient to keep your data in one table and use filters, formulas and Pivot Tables to extract subsets and summary data.


SG

Reply

Numbers 14.3 Copy and paste worksheet.

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