Google Sheets tutorials
Formulas, formatting and data tips for Google Sheets, explained step by step.
Google Sheets
How to Freeze Rows and Columns in Google Sheets (and Excel)
Keep your header row or first column visible while you scroll. How to freeze and unfreeze rows and columns in Google Sheets, with the Excel equivalent.
Google SheetsHow to Highlight Duplicates in Google Sheets
Use conditional formatting with a custom formula to highlight duplicate values, entire duplicate rows, or only the second and later copies in Google Sheets.
Google SheetsHow to Remove Duplicates in Google Sheets (3 Easy Ways)
Remove duplicate rows in Google Sheets with the built-in cleanup tool, the UNIQUE function, or a COUNTIF helper column. Step-by-step with examples.
Google SheetsHow to Use VLOOKUP in Google Sheets (With Examples)
Learn VLOOKUP in Google Sheets: the syntax, a worked example, exact vs approximate match, and how to fix #N/A and #REF! errors.