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.
Adding borders to a cell (or range of cells) is a common way to draw attention to the cell contents. Sheets provides a ...
Discover MoreDo you remember working with Roman numerals when you were in school? Sheets allows you to put those lessons to work by ...
Discover MoreGet lots of files into Drive, and sooner or later you'll want to organize them in some way. Sheets includes a great ...
Discover MoreThere are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Copyright © 2018 Sharon Parq Associates, Inc.
Comments