How do I change 14 sheets in a spreadsheet into a book for one year and being able to add additional years?

Question

I have made a spreadsheet that has 14 sheets to it but I am wanting to use this exact format for the coming years. How do I turn what I have into a book for one year and being able to add additional years with the same sheets? Is this even possible?

Answer 1

Hi D Routzahn,

Thank you for posting, I am here to help. To make use the exact format from your spreadsheet template for the coming years please try this steps.

Right click the Tab at the bottom of that sheet and select 'Move or Copy'.

In the resulting dialog, check the box marked 'Create a Copy' That will duplicate the sheet for you.

Then you can rename each sheet by right clicking the sheet tab and choosing 'Rename'

looking forward to helping you out.  If you need more help please let me know. If the answer is helpful, please click "Accept Answer".

Best regards,

Jansher