How to Create a Drop-Down List in Google Sheets
Add a drop-down list in Google Sheets using typed items, a cell range, or preset lists. Includes colors, multiple selections, mobile steps, and fixes.
Read guideTopic
Google Sheets tutorials
Work confidently with spreadsheet data, formulas, formatting, and cleanup.
How to Lock Cells in Google Sheets (Protect Cells, Ranges, and Sheets)
Lock cells in Google Sheets with Data → Protect sheets and ranges. Learn how to restrict editors, show warnings, lock formula references, and unlock cells.
Read guideHow to Remove Duplicates in Google Sheets
Learn how to remove duplicate rows in Google Sheets, choose which columns to check, and avoid accidentally deleting important data.
Read guide