How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Google Sheets vs Excel: Which Spreadsheet Fits?Google Sheets is usually the better fit for browser-based collaboration and simple shared workflows; Microsoft Excel is generally stronger for advanced analysis,…
- Google Sheets: Color Cells Based on CheckboxesYes. In Google Sheets, use conditional formatting to change a cell’s fill color when its checkbox is checked: select the checkbox cells,…
- Google Sheets: What It Is, How It Works, and When to Use ItGoogle Sheets is Google’s spreadsheet application for creating, editing, and sharing spreadsheets in a web browser. It lets you organize information in…
- Google Sheets Column Running Total: Formulas That WorkTo calculate a running total in a Google Sheets column, enter =SUM($A$2:A2) in B2 when your numbers are in A2:A, then fill…
- Google Sheets Checkbox Strikethrough: Setup GuideGoogle Sheets checkboxes cannot apply strikethrough through the built-in conditional-formatting controls. To strike through a row when its checkbox is checked—and remove…
- Google Sheets Checkboxes: How to Add and Use ThemTo add checkboxes in Google Sheets, select the cells where you want them and choose Insert > Checkbox. A checked box normally…
- Google Sheets Checkbox Strikethrough: How to Set It UpTo strike through a task when its Google Sheets checkbox is checked, select the task cells or rows, open Format > Conditional…
- Google Sheets Checkbox Options: Values, Setup, and UsesGoogle Sheets checkboxes can store the default values TRUE and FALSE, or custom checked and unchecked values such as Yes and No.…
- Google Sheets Checkbox IF Statements: Examples & TipsIn Google Sheets, use an IF formula to return one result when a checkbox is checked and another when it is unchecked.…
- Google Sheets Checkbox in a Cell: How to Add and UseTo put a checkbox in a Google Sheets cell, select the cell or range, then choose Insert > Checkbox. By default, a…
- Google Sheets Checkbox Column: Add and Use CheckboxesTo add a checkbox column in Google Sheets, select the cells where the checkboxes should go, then choose Insert > Checkbox. Each…
- Google Sheets Checkbox Conditional Formatting GuideTo apply conditional formatting to a Google Sheets checkbox, select the cells you want to format, open Format > Conditional formatting, and…
- Google Sheets Checkbox Formulas: Setup and ExamplesIn Google Sheets, add an interactive checkbox with Insert > Checkbox; a checked box has the value TRUE and an unchecked box…
- Google Sheets: Check for Duplicates in a ColumnTo check a Google Sheets column for duplicates, enter a COUNTIF formula beside the first data row: if your values are in…
- Google Sheets Checkbox Color: What You Can ChangeGoogle Sheets does not provide a separate color picker for the checkbox control itself. To make a checked box stand out, use…
- Google Sheets Checkbox: Change Row Color AutomaticallyYes. In Google Sheets, you can change an entire row’s color when its checkbox is checked by applying conditional formatting to the…
- Google Sheets and ChatGPT: How to Use ThemYes—you can use ChatGPT with Google Sheets, but ChatGPT is not the same thing as a built-in Sheets feature. The simplest approach…
- Google Sheets Checkbox and Text in One Cell? OptionsNo—a Google Sheets cell cannot display its native, clickable checkbox and separate label text at the same time. The simplest solution is…
- Google Sheets Cell Dropdown List: Setup and TipsTo create a cell dropdown list in Google Sheets, select the cell or range, choose Insert > Dropdown, add the choices, and…
- Google Sheets Cell Validation: Rules, Lists, and TipsGoogle Sheets cell validation lets you control what people can enter in selected cells, using rules such as a dropdown list, a…
- Google Sheets: Change Cell Color When a Checkbox Is CheckedYes. In Google Sheets, insert a checkbox, then use Format > Conditional formatting to apply a fill color when its value is…
- Google Sheets Budget Tutorial: Build a Monthly PlanTo make a monthly budget in Google Sheets, enter your take-home income, list spending categories, and add columns for planned and actual…
- Google Sheets Can’t Open Apps Script? Fixes That WorkYes—Google Sheets can open Apps Script in a web browser: open the spreadsheet and choose Extensions > Apps Script. If that option…
- Google Sheets British Date Format: Set Dates to DD/MM/YYYYTo use British date format in Google Sheets, set the spreadsheet’s locale to United Kingdom under File > Settings > General >…
- Google Sheets Conditional Formatting: Using BordersNo. Google Sheets’ built-in conditional formatting cannot add or change cell borders when a rule is met; its formatting options include text…
- Google Sheets Australian Date Format: How to Set It UpTo use Australian dates in Google Sheets, set the spreadsheet locale to Australia through File > Settings > General > Locale, then…
- Google Sheets Auto Sort: What Changes Automatically?No—Google Sheets does not automatically re-sort a normal data range whenever a value changes. To keep a separate, automatically updated sorted list,…
- Google Sheets Apps Script Page Not Found? Causes and FixesIf Google Sheets Apps Script says “page not found,” first check that you opened the script editor from the right Google account…
- Google Sheets Array Formula SUM: Examples and FixesTo add values in Google Sheets, use =SUM(B2:B) when the numbers are in column B from row 2 down. Wrapping that formula…
- Google Sheets ARRAYFORMULA with VLOOKUP: How It WorksIn Google Sheets, combine ARRAYFORMULA with VLOOKUP to look up many values at once and return the results down a column. Put…