Making Copies So You Don't Wreck Your Good Stuff
Okay. This lesson is short but it might save you more grief than anything else in this whole course. I mean that.
Here's the situation. You're going to build a sheet you actually like. Inventory, invoices, whatever it is. And at some point, somebody else is going to need to use it, or open it, or "just take a quick look." Your sister, your bookkeeper, Daniel from the bike shop down the street, whoever.
And they will mess it up. Not because they're careless. Just because that's what happens. Someone types over a formula, or deletes a row they thought was blank, or "fixes" something that wasn't broken. It happens to good people. It happened to me.
So we're gonna build a habit right now, before you have anything worth protecting, so it's already automatic by the time you do.
The opinion part, since we're here
Don't share your master sheet. Ever. Share a copy.
I don't care how much you trust the person. I don't care if it's your spouse. You make a copy, you share the copy, and your original stays untouched somewhere only you touch it. This is one of those rules that sounds paranoid until the one time it saves you, and then you're a believer for life.
How to actually do it
Two ways to make a copy, and you should know both.
Making a copy of the whole file: Go to File, then "Make a copy." It'll ask you what to name it and where to put it. Name it something that tells you what it is later, not "Copy of Copy of Inventory (1)." Future-you will thank you. Something like "Inventory - MASTER, do not touch" works. Yes, really, put "do not touch" right in the title. It works better than you'd think.
Duplicating a single tab: Right-click the tab at the bottom, hit "Duplicate." Handy when you want to try something risky on one sheet without touching the rest of the file. I do this constantly when I'm testing a new formula. Break the copy, not the original.
The Daniel story
So my husband Daniel fixes up bikes on the side. Has for years. And for the longest time he wouldn't track anything. Cash in a coffee can, basically. Numbers in his head. Drove me a little nuts, honestly, because I could see exactly how much money he was probably losing track of.
I built him a sheet. One page. No fancy stuff, no tabs, no formulas he'd have to think about. Just what came in, what went out, what he charged for parts versus labor.
And here's the thing. I gave him a copy. Not the original I built it in. Because I knew, I just knew, that at some point he was gonna delete a column trying to "clean it up" or type a note in the wrong cell. And he did, actually, pretty early on. Deleted a whole row of formulas trying to make room for something. But it didn't matter, because my original was sitting safe somewhere else, and I just copied it again and handed him a fresh one.
He still won't fully admit I was right about tracking it. But he uses the sheet every week now. That's the win. I don't need the credit, I just need him not calling me in a panic asking where his money went.
A couple practical notes
If you're sharing with someone who's not great with computers, or you genuinely don't trust their clicking habits, look into "view only" or "commenter" access instead of "editor." You can set that when you click Share. It won't stop every problem but it stops a lot of them.
And if you do hand someone editing access to a copy, tell them out loud, "hey, this is a copy, mess it up all you want, I've got the original." Takes the pressure off them too. Nobody does their best work worried they're gonna break something important.
One more thing. Google Sheets does keep a version history, File then "Version history," and it can sometimes rescue you if something gets overwritten. It's genuinely handy. But I don't want you relying on it as your safety net. Think of it as the seatbelt, not the reason you drive fast. Make the copy first.
Before next time
Take whatever sheet you've started so far, even if it's just two columns, and practice making a copy of it. Rename that copy something obviously different from the original. Just get the motion into your hands before you actually need it.