Turn on autosave right now, before we do anything else
Okay sooo. Before we type a single number, I need you to go turn on autosave. Not "in a minute." Now. I'll wait.
Here's the thing. I do not care how organized you think you are. I do not care if you're the kind of person who saves obsessively with Ctrl+S every four seconds. Autosave still matters, because the moment you forget just once is the moment something goes wrong.
Mine was apple juice. Dawson, who was three at the time, climbed up next to me while I was mid-formula on the budget sheet and dumped a full cup of apple juice straight into the keyboard. I lost about twenty minutes of work. Not because the juice destroyed the file, the file was fine, but because autosave was off and I hadn't saved in a while and the laptop needed a minute (and a towel, and a small amount of panic) before I could even get back in. Twenty minutes doesn't sound like much until you're staring at a blank formula bar wondering what you'd already figured out.
I turned autosave on that day. I have not turned it off since. Consider this me preaching.
How to actually do it
If you're in Google Sheets: you don't have to do anything. It's already on. Every change you make saves automatically to Google Drive, and you'll see "Saving..." or "Saved to Drive" in the little status area near the file name. This is one of the genuine advantages of Sheets and I'll say that plainly even though I mix up my shortcuts between the two platforms constantly.
If you're in Excel: it depends on where your file lives.
- If your file is saved to OneDrive, there's a toggle at the top left labeled AutoSave. Flip it on. It should turn from gray to on, and now Excel is saving your changes continuously, same as Google Sheets.
- If your file is just sitting on your computer's hard drive and not in OneDrive, AutoSave won't be available at all. You've got two choices: move the file into OneDrive so autosave works, or just get serious about manually saving every few minutes with Ctrl+S. I'll be honest, I think option one is better. Fewer things to remember is always better.
Either way, take thirty seconds right now and check your setup before we move on. This is the least exciting five minutes of the whole course and also maybe the most important.
Why I'm this insistent about something so boring
Because the boring stuff is what saves you. Not gonna lie, when I talk about spreadsheets in this class I get more animated about formulas and charts, because those are the fun parts, the parts where you actually get an answer to your question. Autosave isn't fun. It's a seatbelt. You don't think about it until the one day you desperately need it to have been on.
This connects to something I believe pretty strongly about this whole subject, which is that precision you won't maintain is worse than a rough habit you'll actually keep. A perfect manual-save routine that you follow for two weeks and then forget is worse than autosave, which you turn on once and never think about again. Set up the thing that protects you automatically. Don't rely on your future self to remember to be careful. Your future self is busy, or distracted, or has a toddler with a juice cup.
A quick related story, because it's on my mind
I spent an entire Saturday, once, building a chart to show our grocery spending by month. I was proud of it. Colors, labels, the whole thing looked sharp. I showed Casey and he looked at it for about four seconds and said, "okay so we spend a lot in December."
That's it. That's what he got from my entire Saturday.
And here's the thing, that's the chart working. It's supposed to be boring and obvious. I bring this up here because it's the same energy as autosave. You put in the setup work once, it does its job quietly in the background, and the payoff isn't exciting, it's just that nothing bad happens. A good chart tells you one true thing without a paragraph of explanation. A good autosave setting means you never have to tell me your apple juice story.
One honest caution
Autosave means you can't "undo" a bad session by just closing the file without saving, the old trick where you close without saving to throw away a mess you made. Once autosave is on, your mistakes save too. That's fine, that's what Ctrl+Z and version history are for, but it's a real difference in how these tools behave and I'd rather you know it now than get surprised by it later.
Before next time
Go check your autosave setting on whatever you're using for this class, Sheets or Excel, and if it wasn't on, turn it on before we build anything real together. That's the whole assignment.
- C