Copying column headings and layout from one sheet to a new one

TrevorM

Good morning all

We've had a message pop up stating that we've reached our quota for one of the sheets we're using.

I'd like to be able to quickly replicate the sheet again on another new sheet, along with the form we use, colour scheme, and current layout. 

Is this possible?

Andrée Starå

Hi Trevor,

Yes, it is.

When you have your sheet open:

File-->Save as New--> Choose the options that you want under the "Data & Formatting Options"

In your home section:

Right click on the sheet-->Save as New--> Choose the options that you want under the "Data & Formatting Options"

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

TrevorM

Hello Andree,

Thanks for your reply.

I'm not looking to copy over any previous information, or attachments etc. I just wish to copy the form and the column headings so I can start a new sheet over again.

Is this what you mean?

Andrée Starå

Happy to help!

Yes, it is. If you only want the columns and form, you can uncheck everything except "Forms" when you save as new, and you will get what you want.

If you need to do this multiple times, then I would recommend that you save the sheet as a template instead with the same settings as above.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

TrevorM

Legend!

That really helps. Thanks very much.

Do you have any idea why the new form automatically add 50 blank lines to the new sheet I've now created then? Can I get rid of blank ones somehow?

I have tried deleting them but as soon as I come off the sheet and come back to it again there are 50 blank rows back again

Andrée Starå

*Blushing*

You're welcome!

The 50 blank lines are by default, and there is no way to get rid of them.