Learning how to use Google Sheets gives you a free, powerful spreadsheet that runs in any web browser and saves your work automatically. Google Sheets is Google’s answer to Microsoft Excel, and it handles budgets, schedules, inventories, and data analysis without costing a penny. Because it lives in the cloud, you can build a spreadsheet on your laptop, check it on your phone, and share it with others who can all edit at the same time.
This getting-started guide walks you through the fundamentals: creating a spreadsheet, entering and formatting data, writing your first formulas, and sharing your work. Whether you are tracking household expenses or organizing a team project, these basics will get you productive quickly, even if you have never touched a spreadsheet before.
Understanding the Google Sheets Layout
A spreadsheet is a grid of cells arranged in columns and rows. Columns are labeled with letters (A, B, C) across the top, and rows are numbered (1, 2, 3) down the side. Each cell has an address that combines its column and row, such as B4. You type data or formulas into cells, and the formula bar just above the grid shows the full contents of whichever cell is selected. A single file can hold multiple sheets, shown as tabs along the bottom.
How to Create and Fill Your First Spreadsheet
Follow these steps to build a simple, working spreadsheet.
- Open Google Sheets. Visit sheets.google.com, sign in, and click the blank spreadsheet tile or choose a template like a budget or schedule.
- Name your file. Click “Untitled spreadsheet” in the top-left corner and type a clear name. It saves instantly to Google Drive.
- Add headers. Click cell A1 and type a column title such as “Item,” then press Tab to move right and add more headers like “Cost” and “Date.”
- Enter your data. Click a cell and type. Press Enter to move down or Tab to move across. You can paste data from other sources too.
- Write a formula. Click an empty cell, type =SUM(B2:B10), and press Enter to add up a range of numbers automatically.
- Format the cells. Use the toolbar to bold headers, change number formats to currency or dates, add borders, and shade cells with color.
- Share your work. Click the Share button, add email addresses or copy a link, and choose whether people can view, comment, or edit.
Writing Your First Formulas and Functions
Formulas are what make a spreadsheet powerful. Every formula begins with an equals sign. You can do simple math like =A1+A2 or use built-in functions for common tasks. The most useful starter functions are SUM to add numbers, AVERAGE to find the mean, COUNT to count entries, MAX and MIN to find the largest and smallest values, and IF to make decisions based on a condition.
Relative and Absolute References
When you copy a formula, cell references normally shift automatically. Typing =B2*C2 and copying it down becomes =B3*C3, then =B4*C4, which is perfect for repeating a calculation on each row. To lock a reference so it never moves, add dollar signs, as in =B2*$D$1, which keeps pointing at cell D1 no matter where you copy it. Press F4 while editing a reference to add the dollar signs quickly.
Start with SUM and AVERAGE on a small list of numbers. Select the range with your mouse and Sheets even shows a running total in the bottom-right status bar before you write a single formula.
Try VLOOKUP or the newer XLOOKUP to pull matching data from another table, and use conditional formatting to color cells automatically based on their values.
Formatting and Organizing Your Data
Good formatting turns a wall of numbers into something readable. Select cells and use the toolbar to apply currency, percentage, or date formats. Bold your header row, add borders to define a table, and use Format then Conditional formatting to highlight values automatically, such as coloring negative numbers red. To sort or filter, select your data and open Data then Create a filter, which lets you rearrange rows or hide entries you do not need.
| Function | What it does | Example |
|---|---|---|
| SUM | Adds a range of numbers | =SUM(B2:B10) |
| AVERAGE | Finds the mean value | =AVERAGE(B2:B10) |
| COUNT | Counts cells with numbers | =COUNT(B2:B10) |
| IF | Returns a value based on a test | =IF(B2>100,”High”,”Low”) |
| VLOOKUP | Looks up a matching value | =VLOOKUP(A2,D:E,2,FALSE) |
For more spreadsheet and productivity tutorials, browse our library of how-to guides.
Frequently Asked Questions
Is Google Sheets free?
Yes. Google Sheets is free with any personal Google account and shares 15 GB of storage across Google Drive. Paid Workspace plans add business features and more storage but are not needed for personal use.
Can Google Sheets open Excel files?
Yes. Upload an .xlsx file to Google Drive and open it with Sheets. You can edit it and download it back to Excel format, though a few advanced macros or charts may need adjusting.
How do I add up a column of numbers?
Click an empty cell below the column, type =SUM( then select the range of numbers with your mouse, and press Enter. Sheets adds them all instantly and updates the total whenever the data changes.
Does Google Sheets work offline?
Yes. Enable offline access in the Chrome browser through Google Drive settings, or use the mobile app’s offline mode. Your edits sync automatically once you reconnect to the internet.
What is the difference between Google Sheets and Excel?
Both are spreadsheet programs with similar functions. Google Sheets is free, browser-based, and built for real-time collaboration, while Excel offers more advanced analysis tools and works well offline as a desktop app.
