📊 Lesson 1.2: Setup, the Interface & Your First Spreadsheet

Signing In & Getting to Sheets

Getting to Google Sheets is refreshingly simple: there's nothing to download and nothing to install. If you can open a web browser and you have a Google account (the same one behind a Gmail address), you're ready. Open a new browser tab and go to sheets.google.com. If you're not already signed in, Google will ask for your account first; sign in, and you'll land on the Sheets home screen.

The home screen is your launch pad. Across the top you'll see a row for starting a new spreadsheet: a Blank option (an empty grid — that's what we'll use) and a gallery of templates for common jobs like budgets, schedules, and invoices. Below that is a list of your recent spreadsheets, newest first, so you can jump back into whatever you were working on. That's really all the home screen does: start something new, or reopen something you already have.

A word about autosave, because it surprises people coming from older software: there is no Save button, and you never need one. Every change you make is written to Drive within a second or two, all by itself. We'll come back to this in Section 5, but keep it in mind from your very first keystroke — you genuinely cannot lose your work by forgetting to save.

Free personal account vs a Workspace account

You can use Sheets with a free personal Google account (a normal Gmail address) and everything in this course works perfectly on it — no payment, ever. Some people instead sign in with a Google Workspace account, which is the paid, business/school version an organization sets up (your login might look like you@yourcompany.com rather than @gmail.com). Workspace adds admin controls, shared team drives, and more storage, and a school or employer's rules may apply to what you can share. For learning, the free personal account is ideal.

⚠️ Important Note: Exact prices, storage limits, and edition names for Google Workspace and Google One change over time, so we won't quote figures that go stale. If you're curious about the paid tiers, check Google's current pages — we link them in Lesson 8.1 — but rest assured you need none of it here.

A Guided Tour of the Interface

Open a blank spreadsheet (click Blank) and let's get our bearings. It can look busy at first, but the whole interface is just a handful of named parts, each with one job. Think of it like the dashboard of a car: once you know what each control is for, you stop noticing the clutter.

From top to bottom, here's what you're looking at:

• The file name (top-left) — right now it says "Untitled spreadsheet." Click it to rename the whole file. We'll do this in the project.
• The menu bar — the words File, Edit, View, Insert, Format, Data, Tools, Extensions, Help. This is where everything lives. When you can't find a feature, the menu bar always has it; browsing these menus is one of the best ways to learn what Sheets can do.
• The toolbar — the row of icons below the menus (undo, print, bold, alignment, borders, and more). These are shortcuts to the most common commands so you don't have to open a menu every time.
• The Name Box — the small box on the left just above the grid. It shows the address of the cell you've selected (like A1), and you can type an address into it to jump straight there.
• The formula bar — the long bar to the right of the Name Box. It shows the true contents of the selected cell. This matters: a cell might display 150 but actually contain the formula =100+50 — the formula bar reveals what's really inside.
• The grid — the main event: a huge sheet of empty cells where your data goes.
• Sheet tabs (bottom-left) — one tab per page inside this file, plus a + to add another. More on these below.

Rows, columns, and cells

The grid is organized by rows and columns. Rows run horizontally and are labeled with numbers down the left side: 1, 2, 3, and so on. Columns run vertically and are labeled with letters across the top: A, B, C… and after Z it continues AA, AB, AC (a sheet can have thousands of columns). Where a row and a column cross, you get a single cell — the basic box that holds one piece of information.

The cell you've currently clicked is the active cell. It has a bold blue outline, and its row number and column letter light up too, so you can always see "you are here." Whatever you type goes into the active cell. There is only ever one active cell at a time (though you can select a whole block of cells, as we'll see next).

Why keep multiple tabs in one file? Because related data belongs together. A "2026 Budget" spreadsheet might have a January tab, a February tab, and a Summary tab — three pages, one file, and formulas on one tab can even pull numbers from another. We'll use that superpower later; for now, just know the tabs at the bottom are separate pages inside your one file.

Cell Addresses & Navigating the Grid

Every cell has an address — its column letter followed by its row number, with the letter always first. The top-left cell is A1 (column A, row 1). The cell one to its right is B1; one below it is A2. This "A1 notation" is the address system the whole spreadsheet world uses, and it's exactly like naming a square on a map or a seat in a theater (row and section). Once addresses feel natural, formulas will too, because a formula is mostly just a set of instructions about which addresses to work with.

You'll also want to talk about a range — a rectangular block of cells — which you write as the top-left address, a colon, and the bottom-right address. So A1:C5 means "every cell from A1 down to C5," a block three columns wide and five rows tall. You'll use ranges constantly: SUM(B2:B13) adds up a whole column of numbers, for instance. Read the colon as the word "through": A1 through C5.

Moving around without touching the mouse

You can click any cell to select it, but you'll be far faster if you let the keyboard do the walking. These are the moves worth building into muscle memory from day one:

• Arrow keys — move the active cell one cell up, down, left, or right.
• Enter — confirm what you typed and drop down one cell. Great for entering a column of numbers.
• Tab — confirm and move right one cell. Great for entering a row across. (Handy trick: type a row using Tab between cells, then press Enter, and you'll jump back to the start of the next row automatically.)
• Ctrl + arrow (Cmd + arrow on a Mac) — jump to the far edge of your data in that direction. In a big sheet this leaps hundreds of rows instantly instead of one at a time.
• The Name Box — click it, type an address like D50, and press Enter to teleport straight there. Perfect for jumping to a distant part of a large sheet.

⚠️ Important Note: Keyboard shortcuts are the same idea across spreadsheets, but a few differ by operating system — Windows and ChromeOS use Ctrl where a Mac uses Cmd (⌘). When we write "Ctrl/Cmd," reach for whichever your keyboard has. You can always see the full list inside Sheets via Help → Keyboard shortcuts.

Creating & Naming Your First Spreadsheet

Let's turn that blank grid into a real, named file. There are two easy ways to create a new spreadsheet, and both give you the same thing:

• From the Sheets home screen, click Blank (or pick a template).
• From anywhere, type sheets.new into your browser's address bar and press Enter — a tidy shortcut that opens a fresh blank spreadsheet instantly.

Name the file

A brand-new file is called "Untitled spreadsheet," which is a terrible name to find later. Fix it first: click that title in the top-left corner and type a real name, like My Monthly Budget or Reading List 2026. Press Enter. That's it — the file is renamed, and (of course) the change saves itself. A clear, specific name is the difference between finding this sheet in five seconds next week and hunting through a pile of "Untitled spreadsheet" files.

Rename a tab

Look at the bottom-left: your one tab is named Sheet1. Give it a meaningful name too. Double-click the tab (or click the little arrow on it and choose Rename), type something like January or Books, and press Enter. Naming tabs matters even more once you have several, because formulas can reference other tabs by name — a well-named tab makes those references readable.

Add a second tab

Click the + at the far bottom-left to add a new sheet. A fresh page appears (named Sheet2 until you rename it), completely independent of the first — its own grid of empty cells. You can click between tabs to switch pages, drag a tab left or right to reorder, and use a tab's little arrow menu to rename, duplicate, delete, or color-code it. Try adding one now and calling it something like Notes or Summary, so the "one file, many pages" idea feels concrete.

Here's the hierarchy we've been describing, from the biggest container down to the smallest unit. Keep this picture in your head and you'll always know where anything lives:

Drive holds your files; a spreadsheet is one file; each tab is a page inside it; each cell is a box on that page; and your data lives in the cells. Every feature in this course fits somewhere on this ladder.

Autosave, Version History & Finding Your Work

We've mentioned autosave a few times — now let's make it real, because it changes how it feels to work. As you type, watch the area just right of the menu bar: it briefly reads "Saving…" and then "Saved to Drive." There is no Save button because there's nothing to save manually; your work is continuously written to the cloud. Close the tab, lose your internet, spill coffee on your laptop — your sheet is safe in Drive, right up to your last keystroke.

Version history: a time machine

Because Sheets keeps saving, it can also keep a history of past versions. Open File → Version history → See version history and you'll see a timeline of earlier states of the file. You can click any point to preview how the sheet looked then, and restore it if you like. This is your safety net: made a mess, deleted the wrong thing, or just want to see what changed? Roll back. It's the technical reason behind the "you can't break anything" promise from Lesson 1.1 — every mistake is reversible.

A brief note on working offline

Sheets is cloud-first, but it can work without an internet connection if you turn on offline access ahead of time (in Chrome, via Google Drive's settings). Changes you make offline sync back to Drive the next time you're connected. For this course you don't need it — but it's good to know the option exists for a flight or a spotty connection. We won't dwell on setup here since the steps shift over time; if you need it, search Google's help for "use Google Drive files offline."

Reopening your sheet from Drive

Since your sheet lives in Google Drive, there are a few reliable ways back to it:

• Return to sheets.google.com — your file appears in the recent list on the home screen.
• Go to drive.google.com and find it among your files (you can search by the name you gave it — another reason good names matter).
• Bookmark the sheet's own browser tab if it's something you'll open often.

🎯 Project: Your First Real Spreadsheet

Now you'll create the actual spreadsheet you'll grow across this whole course, using the Spreadsheet Plan you wrote in Lesson 1.1. We're not adding formulas yet — that's Module 2 — just setting up the file and getting your first real rows of data into the grid. If you skipped the plan last lesson, no problem: use a simple monthly budget (columns Date, Category, Description, Amount) and follow along.

Tab name: January

     A          B           C                 D
1    Date       Category    Description       Amount
2    2026-01-02 Groceries   Weekly shop       64.20
3    2026-01-03 Transport   Bus pass          30.00
4    2026-01-05 Dining      Coffee with Sam   8.50

Notes tab (second tab): jot reminders here for now.

Best Practices for Getting Set Up

✅ Do's

• Name the file first, before you do anything else. A specific name now saves a frustrating search later.
• Rename tabs to something meaningful. "January" and "Summary" beat "Sheet1" and "Sheet2" every time, especially once formulas reference them.
• Learn a few keyboard moves. Enter, Tab, and Ctrl/Cmd+arrow will make you noticeably faster within a day.
• Trust autosave. Let go of the Save-button reflex and lean on version history when you need a rewind.

❌ Don'ts

• Don't leave files called "Untitled spreadsheet." Future-you won't know which is which.
• Don't memorize button positions. The toolbar and menus shift over time; remember what each area is for instead.
• Don't panic about mistakes. Ctrl/Cmd+Z and version history mean nothing you do is permanent.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

You went from theory to a real, named spreadsheet with a header row and live data in it. You can name every major part of the interface, read and type cell addresses, move around the grid with the keyboard, and manage the file and its tabs — all while trusting that your work is safe. That's a genuinely capable foundation, and everything from here builds directly on this sheet.

❓ Common Questions at This Stage

🔭 Looking Ahead

In the next lesson — Lesson 1.3: Entering, Editing & Formatting Data — we take the raw rows you just typed and make them clean and readable: the data types Sheets understands, faster ways to enter and edit, the fill handle, and formatting like currency, dates, bold headers, and freezing the header row so it stays put as you scroll.

✅ Before the Next Lesson

• Make sure your starter spreadsheet is created, named, and has a header row plus a few data rows
• Confirm you can reopen it from the Sheets home screen or Drive
• Write your Learning Journal entry for this lesson

📚 Additional Resources

• sheets.google.com — open the app
• drive.google.com — where your files live
• Google Sheets Help Center (Google Support)