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, 2026
AUTHORJosephine
Spreadsheet reviewer at SheetSteps
Josephine writes and checks SheetSteps articles about formulas, templates and everyday spreadsheet work.
ARTICLES
Written by Josephine
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 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 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 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
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 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
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
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
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 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 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
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
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
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
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
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
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
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 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
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
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
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
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
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