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.
Spreadsheets
8 posts
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.