Google Sheets Made Simple: A Beginner's Guide

If the word “spreadsheet” makes you want to close the tab, take a breath — Google Sheets is really just a grid for organizing information, and you do not need to be “good at spreadsheets” to use the basics. This guide walks you through entering information, adding up a column of numbers, sorting a list, and sharing a sheet carefully. Take it one step at a time. There is no rush.

What Google Sheets is, in plain words

A spreadsheet is a grid made of rows and columns. Rows run across and are numbered 1, 2, 3. Columns run up and down and are lettered A, B, C. Where a row and column meet is called a cell, and each cell is named by combining the two, like B3. People use Sheets for all kinds of everyday things — budgets, contact lists, medication trackers, home project lists, and travel plans. Your screen may look slightly different on a phone than on a computer, but the same basic steps work either way.

Four things you can do right now

1. Create a spreadsheet and enter information

Open Google Sheets and choose Blank or the + button to start a new spreadsheet. Click or tap a cell, type your information, and press Enter or tap another cell to move on. Try to keep one piece of information per cell — for example, a name in one cell and a phone number in the next — which keeps the sheet easy to read and easy to sort later. If you need to change something, just double-click or tap the cell, edit the contents, and press Enter. Undo is always there if you change the wrong cell by mistake.

2. Add up a column with a simple total

Click the cell where you want the total to appear — usually just below the last number in a column. Type =SUM(B2:B10), using the actual range of cells that hold your numbers, and press Enter. Sheets will add up everything in that range and show the result. If formulas feel unfamiliar, start small: try totaling one short column, like a simple household budget with a category in column A, a planned amount in column B, and an actual amount in column C, with a SUM total at the bottom.

3. Sort a list into order

Select the table or column you want to sort, choose Data, then Sort, and pick A to Z, Z to A, or number order. If your list has several columns — like a contact list with names in one column and phone numbers in another — make sure you select the whole table before sorting, so the related columns stay lined up together and nothing gets scrambled.

4. Share a spreadsheet safely

Click Share, enter the person’s email address, choose whether they should be a Viewer, Commenter, or Editor, and send. Viewer can only look, Commenter can leave notes, and Editor can change your formulas and data — so choose the lowest permission that gets the job done. Restricted access, where only the specific people you added can open the file, is the safer default. “Anyone with the link” is easier to use but less private, since a link can be forwarded on to people you never intended to share with. A shared budget or contact list can contain personal information, so it is worth sharing carefully.

What the full printable guide adds

This lite guide gets you comfortable with the everyday basics safely. The full Google Sheets Made Simple printable guide from our Etsy shop goes further, with large-print, step-by-step pages you can keep by your computer, including:

• Basic formatting — bold, text size, and number formats — to make a sheet easier to scan
• Resizing columns so your information isn’t cut off or crowded
• Using a simple filter to show only certain rows, without deleting anything
• Downloading or printing your sheet as an Excel file or a read-only PDF
• Changing or removing someone’s access once a project or collaboration ends
• A one-page privacy reminder and a five-item quick-reference card

It’s the same friendly, no-jargon approach — just all in one place, ready to print, so you never have to search for these steps again.