Copying a Spreadsheet

by Allen Wyatt
(last updated March 6, 2014)

When I've put a lot of work into developing a spreadsheet, I often don't want to mess up what I've done in order to make additional changes to the spreadsheet. This is particularly true in Sheets, where any changes are immediately saved in the spreadsheet without any effort on my part.

This is where making a copy of a spreadsheet comes in handy. Once I've got my spreadsheet the way I want it, all I need to do is select the Make a Copy option from the File menu. Sheets displays the Copy Document dialog box. (See Figure 1.)

Figure 1. The Copy Document dialog box.

The proposed title for the copy isn't cast in stone; you can (and should) change it to anything you want. If the spreadsheet is shared with others, you can also instruct Sheets to share the copy with the same people. (Just click the Share It with the Same People check box.)

When you click OK, Sheets quickly makes the copy. The original spreadsheet is closed and you are, instead, immediately working in the new copy.

You should note the one caveat appearing in the Copy Document dialog box: Comments won't be copied when Sheets saves out the new spreadsheet. If it is important for you to maintain the comments, you might want to make the copy of the spreadsheet in Drive instead of within Sheets.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Using R1C1 Formula References in a Macro

Besides the regular way of displaying formulas, Excel can also display them using what is called R1C1 format. If you are ...

Discover More

Automatic Page Numbers across Multiple Documents

Word allows you to specify the starting page number for a document, which comes in handy if you have multiple documents ...

Discover More

Getting Rid of All Rows Except the One for the Latest Date

As you use Excel to collect data over time, sometimes winnowing out the latest data can present a challenge. Here are a ...

Discover More
More DriveTips

Adding a Drawing to Your Spreadsheet

Numbers alone do not define spreadsheets. Google Drive allows you to also add drawings to a spreadsheet, which can be ...

Discover More

Hiding a Chart's Legend

When you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. You may not want ...

Discover More

Keeping Row and Column Headings in Sight

When you create a spreadsheet, it is common to place headings at the top of each column and the left of each row so you ...

Discover More
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is eight minus 7?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)