How to Alphabetize in Google Sheets (2026 Guide)
Alphabetize in Google Sheets: sort a single column, sort a range while keeping rows together, sort the whole sheet, use the SORT function, and handle headers.
Google Sheets
17 posts
How to Highlight Duplicates in Google Sheets (2026 Guide)
Highlight duplicates in Google Sheets with a COUNTIF conditional formatting rule: flag a single column, whole rows, find duplicates, then remove them.
How to Make a Graph in Google Sheets (2026 Guide)
Make a graph in Google Sheets: select your data, insert a chart, pick the right chart type, customize colors and labels, and move the chart to its own sheet.
How to Merge Cells in Google Sheets (2026 Guide)
Merge cells in Google Sheets: merge all, merge horizontally, merge vertically, center text across columns, unmerge, plus the sorting caveats to know first.
How to Use COUNTIF in Google Sheets (2026 Guide)
Use COUNTIF in Google Sheets to count cells by condition: text, numbers, wildcards, and dates, plus COUNTIFS for multiple criteria, with copy-paste examples.
How to Use Google Sheets: A Beginner Guide (2026)
Learn how to use Google Sheets from scratch: create and share a sheet, enter data, write basic formulas, format cells, collaborate, and use the mobile app.
How to Use SUMIF in Google Sheets (2026 Guide)
Use SUMIF in Google Sheets to total cells by condition: text, numbers, wildcards, and dates, plus SUMIFS for multiple criteria and the most common errors.
How to Wrap Text in Google Sheets (2026 Guide)
Wrap text in Google Sheets so long entries show in full: use the toolbar or Format menu, compare wrap, overflow, and clip, apply to a range, and on mobile.
Google Sheets Cell Limit: Max Cells, Rows & Columns (2026)
Google Sheets caps spreadsheets at 10 million cells total across all tabs and 18,278 columns (column ZZZ). See the rows, import and per-cell limits for 2026.
How to Create a Drop-Down List in Google Sheets (2026)
Add a drop-down list in Google Sheets using data validation: build one from a typed list or a range, allow multiple selections, color-code options, and edit or remove it.
How to Create a Pivot Table in Google Sheets (2026)
Build a pivot table in Google Sheets to summarize and group data: add rows, columns, and values, change how values are summarized, add filters, and refresh when data changes.
How to Freeze Rows in Google Sheets (and Columns, 2026)
Freeze the header row in Google Sheets so it stays visible while you scroll — plus freezing multiple rows, freezing columns, doing it on mobile, and unfreezing.
How to Remove Duplicates in Google Sheets (4 Methods, 2026)
Remove duplicate rows in Google Sheets with the built-in Data cleanup tool, the UNIQUE function, conditional formatting to find them first, or COUNTIF to flag them.
How to Use Conditional Formatting in Google Sheets (2026)
Highlight cells automatically in Google Sheets with conditional formatting: single-color rules, color scales, formatting based on another cell, and custom formula rules.
How to Use the IF Function in Google Sheets (with Examples, 2026)
Master the IF function in Google Sheets: the syntax, nested IFs, IFS for multiple conditions, and combining IF with AND, OR, and ISBLANK — with copy-paste examples.
How to Use the QUERY Function in Google Sheets (with Examples, 2026)
Use the QUERY function in Google Sheets to filter, sort, and summarize data with SQL-like syntax: SELECT, WHERE, ORDER BY, GROUP BY, LABEL, and pulling from another sheet.
How to Use VLOOKUP in Google Sheets (with Examples, 2026)
Learn VLOOKUP in Google Sheets step by step: the syntax, exact vs. approximate match, looking up data from another sheet, and how to fix #N/A and #REF errors.