Getting Around: Cells, Tabs, and Not Getting Lost
Okay. You've got your paper plan from last lesson. Maybe it's a little messy, maybe you drew arrows all over it. Good. That means it's real.
Now we're opening an actual Google Sheet, and I want to slow way down here, because this is the lesson where people either get comfortable or get lost and don't say anything. So I'm gonna over-explain a little on purpose. Stop me if I'm going too fast.
Cells: the boxes everything lives in
Every little box in your sheet is a cell. Each one has an address, like A1 or C14. The letter tells you the column (going across), the number tells you the row (going down).
That's it. That's the whole trick. A1 is always the top left box. If someone tells you "put that in B3," you go over to column B, down to row 3, and that's your box.
Click on a cell and look up at the top left corner. It'll tell you exactly where you are. Sooo if you ever feel lost, that little box is your GPS. Glance at it, get your bearings, keep going.
Tabs: separate rooms in the same house
See those little labels at the bottom of your screen? Sheet1, Sheet2, whatever they're named? Those are your tabs. Each tab is its own blank page, but they all live inside the same file.
This matters because of what we talked about last time, your three sheets: the one where you enter stuff, the one that does the math, and the one that shows you the summary. Those are probably going to be three separate tabs, not three separate files. Same house, different rooms.
To rename a tab, double-click on it. Type something that actually means something. "Sheet1" tells you nothing. "Sales Entry" tells you everything. Future-you, tired and rushing before closing time, will thank present-you for that.
To add a new tab, there's a little plus sign down in that same bottom-left area. Click it, a blank tab shows up. You can drag tabs left and right to put them in whatever order makes sense to you.
Moving around without losing your mind
A few ways to get around that'll save you actual time:
- Click and scroll works fine when you're new. Nothing wrong with it.
- Arrow keys move you one cell at a time. Handy for small adjustments.
- Ctrl+Home (or Cmd+Home on a Mac) zips you straight back to cell A1. This one's my favorite. When I don't know where I am anymore, I just smash that and start over from home base.
- Typing a cell address into that little box on the top left, next to where it shows your current cell, and hitting enter. Type B20, hit enter, you're at B20. Feels like magic the first time.
You don't need all four. Pick the one or two that feel natural and use those. I mostly live on Ctrl+Home and clicking. That's just me.
A caution, because this trips people up
When you're clicking around, it's really easy to accidentally start typing into a cell that already has something important in it. You click a cell to look at it, your hand's still near the keyboard, you tap a key without thinking, and now you've overwritten a formula you spent ten minutes building.
If that happens, hit Ctrl+Z (undo) immediately. Don't click around first, don't panic-click. Just undo, right away, before you do anything else. It'll usually bring it right back.
Making it not overwhelming
Here's the thing about a blank spreadsheet with a million little boxes stretching off in every direction. It's a lot. Everybody feels that the first time, even people who are good with computers. You don't need to see all of it. You only need to see the part you're working in.
I want you to try something. Pick one small section, say ten rows by five columns, and just work inside that little box for a minute. Get used to clicking, typing, moving to the next cell with Tab or Enter. Don't worry about the thousand empty rows below you. They're not going anywhere. You'll get to them.
This is actually the same instinct I use hosting people at my house. I ran a board game night a while back that somehow turned into eleven people crammed into my kitchen, way more than I planned for. I could've panicked about the whole scene, but instead I just focused on one thing at a time. Does this person have a chair. Does that person have a snack. One corner of the room at a time, and eventually the whole room's taken care of. A spreadsheet's the same. Handle the section in front of you. The rest will still be there.
My opinion here, and I'll probably repeat this all six weeks: simpler is kinder to future-you. Clear tab names, one section at a time, don't try to see the whole forest on day one. The person who's going to use this sheet in March is tired and in a hurry. Set them up now.
Before next time
Open a blank Google Sheet, rename at least two tabs to match your paper plan from last lesson, and just click around for five minutes. Get used to where things are. That's genuinely all I want from you this week.