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

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?

Find more posts tagged with

Forms

Sheets

Conditional Formatting

Importing and Exporting

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Stopping current users from automatically adding new users to Smartsheet
Hi all, Currently on a business plan. How do I stop current users from sharing sheets with other users who have not been officially onboarded into the system by admin? This is driving up our license count and I am trying to stop this from happening. Is this even possible or is it one of Smartsheet's "quirks" (this is…
Does the change in value within a formula not count as a change?
I'm trying to create an automation. In this automation, I want to copy rows when a value changes based on a formula (a count from another sheet), but the automation isn't triggering. What could be causing this issue?
Automation History
How can I validate or identify if an automation was triggered and when? Or if it failed?