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.
8 posts
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.
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.
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.
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.
Highlight cells automatically in Google Sheets with conditional formatting: single-color rules, color scales, formatting based on another cell, and custom formula rules.
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.
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.
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.