Table of Contents
Spreadsheets scare people, and I get why. A blank grid of cells looks like a tax form crossed with a math test. But the first time you make a column add itself up automatically, something clicks, and you start seeing spreadsheets everywhere: budgets, guest lists, workout logs, the lot. Google Sheets is the free, no-install way to get that click, right in your browser.
This guide takes you from opening a blank sheet to writing your first formula, with a few honest detours about the mistakes everyone makes. You will not need any background in math or accounting. If you can fill in a table, you can do this.
What Google Sheets Is
Google Sheets is a free spreadsheet app that comes with your Google account, sitting alongside Docs and Slides. A spreadsheet is just a grid of boxes, called cells, arranged in rows and columns, where you can store numbers, text, and dates, and then have the app do calculations on them for you.
Because it runs in your browser and saves to Google Drive automatically, there is nothing to install and no save button to forget. It is the free cousin of Microsoft Excel, and if you have used one, the other feels familiar. Our guide on how to use Excel covers the same ideas if you ever switch camps.
Getting In and Getting Oriented
Go to sheets.google.com, or click the grid of dots in Gmail and pick the Sheets icon. Choose a blank spreadsheet to start clean, or a template if you want a budget or schedule already laid out. A new sheet opens as that intimidating grid, but it is friendlier than it looks.
Columns run across the top labeled A, B, C; rows run down the side numbered 1, 2, 3. So the top-left box is cell A1, the one to its right is B1, and so on. That little coordinate system is the whole secret to formulas later, so it is worth getting comfortable with now. Rename the file from “Untitled spreadsheet” while you are at it; future-you will be grateful.
Entering Data and Simple Math
Click a cell and type to enter a number, a word, or a date, then press Enter to drop down a row or Tab to move right. To fix something, click the cell and retype, or double-click to edit inside it. This is just filling in a table, and you already know how to do that.
Here is the moment it gets fun. Click an empty cell, type an equals sign, then something like =5+3, and press Enter. The cell shows 8. The equals sign is how you tell Sheets “do some math here,” and it is the doorway to everything the app can do. Try =10*4 or =100/5 and watch it work.
Formulas Without the Fear
The real power comes from pointing at cells instead of typing fixed numbers. Put 10 in A1 and 20 in A2, then in A3 type =A1+A2 and press Enter. A3 shows 30, and if you change A1 to 50, A3 updates itself. That live link is why spreadsheets beat a calculator: change one number and everything depending on it recalculates instantly.
For longer columns, the SUM function saves you. Type =SUM(A1:A10) and Sheets adds up every value from A1 down to A10 in one go. The colon means “through,” so A1:A10 is “A1 through A10.” Master that one function and you have covered a huge share of what everyday spreadsheets are for.
Sharing and Working Together
The blue Share button in the corner lets you invite people by email or hand out a link, and you choose whether each person can view, comment, or edit. Several people can work in the same sheet at once, which is how families split a holiday budget or a team tracks a project without emailing files back and forth.
Since the file lives online, it is safe even if your laptop dies, which is the same logic behind keeping anything important in the cloud. Our guide on what cloud storage is and how it works explains why that matters. And if you prefer writing prose to crunching numbers, our tutorial on how to use Google Docs is the natural partner to this one.
A Few Last Words
A spreadsheet is just a smart table, and Google Sheets is the easiest free door into one. Enter your data, start a formula with an equals sign, lean on SUM for the heavy adding, and share when you are ready. The grid stops looking like a test the moment you watch it add itself up. Build a tiny budget this weekend, even a silly one, and you will see exactly what I mean.