How to make a graph in Google Sheets
Turn a plain range into the right chart, choose better axes, and avoid the defaults that make spreadsheet graphs hard to read.
Published July 13, 2026 · Updated July 27, 2026SHEETSTEPS FIELD GUIDE
The SheetSteps blog
Clear spreadsheet lessons built around real cells, formulas and files.
Published July 13, 2026 · Updated July 27, 2026 · 8 min
How to make a graph in Google Sheets
Turn a plain range into the right chart, choose better axes, and avoid the defaults that make spreadsheet graphs hard to read.
Read article →
Google Sheets invoice template: build one that tracks payment
Create a polished invoice, calculate totals correctly, and keep sent, due and overdue invoices visible in one dependable sheet.
Published July 26, 2026 · Updated July 27, 2026
Google Sheets budget template: a practical monthly system
Plan income, set category limits, track actual spending and see what remains without turning budgeting into a second job.
Published July 25, 2026 · Updated July 27, 2026
How to create a table in Google Sheets
Structure raw data with headers, types, filters and totals so sorting and formulas keep working as the sheet grows.
Published July 24, 2026 · Updated July 27, 2026
How to sort in Google Sheets without scrambling rows
Sort a complete dataset by one or several columns while keeping every record intact.
Published July 23, 2026 · Updated July 27, 2026
How to merge cells in Google Sheets—and when not to
Merge titles and presentation blocks safely while keeping tables sortable, filterable and formula-friendly.
Published July 22, 2026 · Updated July 27, 2026
How to wrap text in Google Sheets
Keep long comments, descriptions and headers visible without making the entire spreadsheet awkward to scan.
Published July 21, 2026 · Updated July 27, 2026
How to use VLOOKUP in Google Sheets
Look up an ID, return the matching entry and fix the range, index and exact-match mistakes behind most VLOOKUP errors.
Published July 20, 2026 · Updated July 27, 2026
How to use SUMIF in Google Sheets
Add entries that match one condition, understand criteria syntax and graduate to SUMIFS when the question has more than one rule.
Published July 19, 2026 · Updated July 27, 2026
How to use IMPORTRANGE in Google Sheets
Pull a reliable range from another spreadsheet, grant access once and combine it with QUERY without creating a fragile chain.
Published July 18, 2026 · Updated July 27, 2026
Google Sheets formula not working? Check these seven things
Diagnose parse errors, wrong results, #N/A, #REF! and formulas displayed as text using a repeatable checklist.
Published July 17, 2026 · Updated July 27, 2026
How to use AI in Google Sheets for real work
Classify, extract, summarize and generate across rows while keeping prompts, outputs and costs predictable.
Published July 16, 2026 · Updated July 27, 2026
How to scrape a website into Google Sheets
Extract organized page data into rows, handle multiple URLs and know when IMPORTXML is enough—or when a browser-backed scraper is needed.
Published July 15, 2026 · Updated July 27, 2026
How to build a Google Sheets dashboard people can read
Turn a clean source table into a compact operating view with trustworthy KPIs, filters and charts.
Published July 14, 2026 · Updated July 27, 2026
Google Sheets calendar template: build a calendar that stays usable
Set up a monthly calendar with real dates, clean event fields and a layout that remains easy to edit.
Published June 8, 2026 · Updated July 24, 2026
Google Sheets formulas: the practical guide to writing them correctly
Learn the parts of a formula, how cell references behave and how to check a result before filling it down.
Published June 9, 2026 · Updated July 25, 2026
How to alphabetize in Google Sheets without mixing up rows
Sort names or labels from A to Z while keeping every record together.
Published June 10, 2026 · Updated July 26, 2026
Google Sheets Gantt chart template: plan work on a real timeline
Turn tasks, owners, dates and status into a timeline that the team can update.
Published June 11, 2026 · Updated July 27, 2026
How to multiply in Google Sheets
Multiply cells, fixed rates and full columns without copying the wrong reference.
Published June 12, 2026 · Updated July 24, 2026
Google Sheets assignment tracker for classes and deadlines
Track classes, due dates, grades and overdue work in one compact student sheet.
Published June 13, 2026 · Updated July 25, 2026
Google Sheets project management template for small teams
Run a project with clear owners, due dates, status and a short weekly review.
Published June 14, 2026 · Updated July 26, 2026
How to search in Google Sheets
Find text, numbers and formulas in one sheet or the full workbook.
Published June 15, 2026 · Updated July 27, 2026
How to sum in Google Sheets
Add a row, a column or selected cells and keep the total accurate as entries are added.
Published June 16, 2026 · Updated July 24, 2026
How to add a column in Google Sheets
Insert one or several columns without losing formulas, formatting or filters.
Published June 17, 2026 · Updated July 25, 2026
ChatGPT for Google Sheets: practical ways to use AI with rows
Write formulas, classify text and process repeated rows while keeping checks around the output.
Published June 18, 2026 · Updated July 26, 2026
How to subtract in Google Sheets
Subtract cells, dates and fixed amounts with formulas that copy correctly.
Published June 19, 2026 · Updated July 27, 2026
ARRAYFORMULA in Google Sheets: fill a full column with one formula
Replace copied formulas with one array formula and handle blank rows cleanly.
Published June 20, 2026 · Updated July 24, 2026
Google Sheets percentage formulas for totals, growth and discounts
Calculate a share of total, percentage growth, discounts and percentage-point differences.
Published June 21, 2026 · Updated July 25, 2026
Best AI for Google Sheets: what to check before choosing a tool
Compare formula help, row processing, scraping and sheet editing by the work you actually need.
Published June 22, 2026 · Updated July 26, 2026
IMPORTHTML in Google Sheets: import tables and lists from a page
Pull a public HTML table or list into cells and fix the most common index mistakes.
Published June 23, 2026 · Updated July 27, 2026
Google Sheets errors: what each message means and how to fix it
Read missing-match, bad-reference, wrong-type, division and formula parse errors without guessing.
Published June 8, 2026 · Updated July 24, 2026
How to use IMPORTXML in Google Sheets
Extract page titles, headings, links and table cells with a tested XPath.
Published June 9, 2026 · Updated July 25, 2026
IMPORTXML not working in Google Sheets: fixes that match the cause
Check the XPath, returned HTML, page access and loading method before replacing the formula.
Published June 10, 2026 · Updated July 26, 2026
Google Sheets conditional formatting not working: 8 checks
Repair rule ranges, custom formulas, date checks and rule order when cells do not format.
Published June 11, 2026 · Updated July 27, 2026
How to hide errors in Google Sheets without hiding broken logic
Use IFNA or IFERROR only after checking why the formula fails.
Published June 12, 2026 · Updated July 24, 2026
Google Sheets SUM that ignores errors
Total a range containing errors without deleting the source rows.
Published June 13, 2026 · Updated July 25, 2026
How to freeze rows and columns in Google Sheets
Keep headers and labels visible while scrolling through a large table.
Published June 14, 2026 · Updated July 26, 2026
How to make a dropdown in Google Sheets
Create a fixed list, set invalid-data behavior and apply it to future rows.
Published June 15, 2026 · Updated July 27, 2026
How to remove duplicates in Google Sheets safely
Delete repeated records while keeping a copy and checking which columns define a match.
Published June 16, 2026 · Updated July 24, 2026
How to filter in Google Sheets
Show only matching rows, save personal filter views and avoid changing what teammates see.
Published June 17, 2026 · Updated July 25, 2026
COUNTIF in Google Sheets: count rows that match one rule
Count statuses, names, dates and text matches with criteria that behave as expected.
Published June 18, 2026 · Updated July 26, 2026
SUMIFS in Google Sheets: sum with several conditions
Total entries by date, owner, status or category with aligned ranges.
Published June 19, 2026 · Updated July 27, 2026
INDEX MATCH in Google Sheets: a lookup that works in either direction
Return a field from any column without relying on a left-to-right table layout.
Published June 20, 2026 · Updated July 24, 2026
XLOOKUP in Google Sheets: cleaner exact-match lookups
Look up IDs, return entries from either side and set a clear not-found result.
Published June 21, 2026 · Updated July 25, 2026
Google Sheets date formulas for deadlines, months and working days
Calculate due dates, month boundaries, elapsed days and working-day schedules.
Published June 22, 2026 · Updated July 26, 2026
Google Sheets inventory template with reorder warnings
Track stock, unit cost, reorder points and incoming quantities in one file.
Published June 23, 2026 · Updated July 27, 2026
Profit and loss template for Google Sheets
Turn monthly income and expense entries into revenue, gross profit and net profit.
Published June 8, 2026 · Updated July 24, 2026
Loan amortization schedule in Google Sheets
Split each payment into interest and principal and track the remaining balance.
Published June 9, 2026 · Updated July 25, 2026
Google Sheets CRM template for a simple sales pipeline
Track contacts, next actions, deal stages and expected revenue without a full CRM app.
Published June 10, 2026 · Updated July 26, 2026
Google Sheets content calendar for planning and publishing
Plan titles, channels, owners, dates and production status in one schedule.
Published June 11, 2026 · Updated July 27, 2026