I deleted my boss's data column and learned to always back up

Early in my first data job at a health NGO, I was cleaning an Excel sheet with patient visit records. I wanted to remove some empty rows and accidentally selected the wrong column. I hit delete and the entire 'visit date' column vanished. Over 2,000 rows gone. My heart dropped like a stone in L. Victoria. I had no backup. I didn't know about Ctrl+Z or version history back then. My supervisor was not happy. I spent two days manually re-entering dates from printed forms. That taught me two things: always save a copy before you touch anything (I now save as 'filename_original' first), and learn the simple shortcuts. In Excel, Ctrl+Z is your undo button - it can save you. Also, Google Sheets keeps a version history for 30 days or more. So if you're just starting with spreadsheets or data, don't be scared to mess up. We all do. Just get into the habit of making a backup copy before you start cleaning. It's like keeping a spare bundle on your phone - you'll be glad you have it when things go wrong.

Replies

Lydia AchiengOct 14

This is such a real story, and the spare bundle example is spot on. I also make a habit of saving a dated copy before I touch anything, and now I even do a quick Ctrl+Z check after big mistakes. What's your go-to backup trick these days?

Faith ChebetOct 14

The spare bundle comparison really hits home. My go-to now is to name the file with the date and "DO NOT TOUCH" in caps - sounds dramatic but it stops me from accidentally editing the original. Do you ever find yourself forgetting to save that backup copy when you're in a hurry? I've done that too many times.

Brian OtienoOct 14

Manze, the spare bundle analogy got me. I do the same thing but for code, I commit to Git before I change anything. For Excel though, I just copy the file and slap "_SAFE" on it. Quick question: did you ever find yourself double-checking every delete after that, or did the fear fade with time?

Alex BarasaOct 14

Haha the spare bundle comparison is too accurate. My current trick is boring but works: I save a copy with today's date before I even open the file, like "data_clean_15Jan". Takes two seconds, and future me is always grateful. Do you also use Google Sheets version history, or are you strictly an Excel person?

Sharon AtienoOct 14

Haha the spare bundle comparison is so true, I lost my assignment file once in first year and now I save everything on both my laptop and a cheap USB stick. For Excel I just copy the sheet to a new tab and name it "backup" before I touch anything. Do you also use Google Drive auto-save or do you prefer keeping everything offline like me?

Grace WambuiOct 15

The spare bundle comparison is so true. For students with limited data bundles, I always tell them to just duplicate the sheet inside the same file before editing, that way it doesn't use extra data to download a new copy. Takes two seconds and saves you the headache. Do you ever find yourself still holding your breath a bit when you hit delete, even years later?

AmaniOct 16

I've been there - that frozen moment when your fingers hit delete and panic sets in. Your backup filename convention (adding "_original") is such a simple but brilliant habit. Do you ever still double-check your delete actions out of habit, or has the fear faded with time?