Google Sheets tutorials
Formulas, formatting and data tips for Google Sheets, explained step by step.
How to Use AVERAGE in Google Sheets (and AVERAGEIF)
Find the average in Google Sheets with AVERAGE, ignore blanks and text, average only cells that meet a condition with AVERAGEIF, and handle the #DIV/0! error.
Google SheetsHow to Change Text to Uppercase or Lowercase in Google Sheets
Change case in Google Sheets with UPPER, LOWER and PROPER. Capitalize names, fix ALL CAPS imports, and replace the original text with the cleaned version.
Google SheetsHow to Make a Chart in Google Sheets
Create a chart in Google Sheets in a few clicks, pick the right chart type, edit titles and colors in the chart editor, and move or delete the chart.
Google SheetsHow to Add Checkboxes in Google Sheets (and Count Them)
Insert checkboxes in Google Sheets, count ticked boxes with COUNTIF, cross out completed tasks automatically, and remove checkboxes.
Google SheetsHow to Color Cells Based on Value in Google Sheets
Automatically color cells in Google Sheets with conditional formatting: single color rules, color scales (heatmaps), coloring a whole row, and a custom formula.
Google SheetsHow to Combine Text from Cells in Google Sheets (CONCATENATE and TEXTJOIN)
Join text from several cells in Google Sheets with the & operator, CONCATENATE and TEXTJOIN. Add spaces and separators, and skip empty cells.
Google SheetsHow to Use COUNTIF in Google Sheets: 8 Practical Examples
Count cells that match a condition with COUNTIF in Google Sheets: text, numbers, wildcards, blanks, not-equal, and COUNTIFS for several conditions.
Google SheetsHow to Calculate Days Between Dates in Google Sheets
Count days, working days, months and years between two dates in Google Sheets with simple subtraction, DAYS, NETWORKDAYS and DATEDIF.
Google SheetsHow to Create a Drop-Down List in Google Sheets
Add a drop-down list in Google Sheets with Insert → Dropdown: type your options, give them colors, use a range as the source, and edit or remove the list.
Google SheetsHow to Filter Data in Google Sheets
Show only the rows you need in Google Sheets: create a filter, filter by values or condition, use filter views so others aren't affected, and the FILTER function.
Google SheetsHow to Use Find and Replace in Google Sheets
Find and replace text across a sheet or whole workbook in Google Sheets, match case, match whole cells, search with regular expressions, and replace inside formulas.
Google SheetsHow 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 Use the IF Function in Google Sheets (With Examples)
Learn the IF function in Google Sheets: syntax, pass/fail example, comparison operators, nested IF, IFS, and combining IF with AND and OR.
Google SheetsHow to Use IMPORTRANGE in Google Sheets
Pull data from one Google Sheet into another with IMPORTRANGE: the syntax, granting access, importing a whole column, and fixing #REF! and loading errors.
Google SheetsHow to Merge Cells in Google Sheets (and When Not To)
Merge cells in Google Sheets horizontally or vertically, unmerge them, avoid losing data, and learn why merged cells can break sorting and filtering.
Google SheetsHow to Number Rows Automatically in Google Sheets
Add row numbers in Google Sheets that update themselves: the ROW function, a sequence that skips the header, autofill, and SEQUENCE for a whole column at once.
Google SheetsHow to Calculate Percentages in Google Sheets
Percentage formulas for Google Sheets: percent of a total, percentage change, increasing or decreasing by a percent, and formatting results as %.
Google SheetsHow to Protect Cells in Google Sheets
Stop people editing important cells in Google Sheets: protect a range or a whole sheet, show a warning or block edits, allow only certain people, and remove protection.
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 Sort Data in Google Sheets (Without Messing Up Your Rows)
Sort by one or several columns in Google Sheets, keep your header row in place, sort A to Z or largest to smallest, and use the SORT function for a live sorted copy.
Google SheetsHow to Split Text into Columns in Google Sheets
Split names, addresses or CSV data into separate columns in Google Sheets with Split text to columns or the SPLIT function. Choose any separator.
Google SheetsHow to Use SUMIF in Google Sheets (and SUMIFS)
Add up only the values that match a condition with SUMIF in Google Sheets. Syntax, category totals, number and date criteria, and SUMIFS for several conditions.
Google SheetsHow to Use the UNIQUE Function in Google Sheets
Get a list of distinct values with UNIQUE in Google Sheets: single columns, whole rows, sorted lists, counting unique values, and common errors.
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.
Google SheetsHow to Wrap Text in Google Sheets
Make long text fit inside a cell in Google Sheets with Wrap, Overflow and Clip, add line breaks inside a cell, and fix rows that won't resize.