How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Google Sheets Project Tracker: Setup and Best PracticesA Google Sheets project tracker is a shared spreadsheet for organizing tasks, owners, deadlines, priorities, and progress in one place. In Google…
- Google Sheets Inventory System: Setup, Limits, and TipsYes. You can build a basic inventory system in Google Sheets by keeping a product list and a separate record of stock…
- Google Sheets Habit Tracker: Build One That WorksA Google Sheets habit tracker is a spreadsheet for recording whether you completed habits on particular days; the simplest version uses one…
- Google Sheets Inventory Template: Build a Simple TrackerYes. You can make a practical Google Sheets inventory template with columns for each item, its location, quantities received and issued, a…
- Google Sheets Budget Template: Build a Monthly PlanA Google Sheets budget template is a spreadsheet for listing income, planned expenses, and actual spending in one place. In a browser,…
- Google Sheets Expense Tracker: Setup and Tips That WorkA Google Sheets expense tracker is a spreadsheet for recording purchases and summarizing where your money goes. Create a table with a…
- Google Sheets: Count Cells Containing Text?Yes. In Google Sheets, use =COUNTIF(A2:A100,"*") to count cells containing text in the range A2:A100. If you want to require at least…
- Google Sheets: Count Cells That Contain Text with COUNTIFTo count cells that contain text in Google Sheets, use =COUNTIF(A2:A100,"*"), replacing A2:A100 with your range. The asterisk is a wildcard that…
- Google Sheets: Count Checked and Unchecked CheckboxesTo count checked checkboxes in Google Sheets, use =COUNTIF(A2:A20,TRUE), assuming the checkboxes are in A2:A20 and use the default values. Count unchecked…
- Google Sheets: How to Copy Conditional Formatting RulesYes. In Google Sheets, copy a cell or range with the conditional formatting you want, select the destination, then choose Edit >…
- Google Sheets Copy Data Validation Rules: How to Do ItTo copy only data validation in Google Sheets, copy a cell or range with the rule, select the destination, then choose Edit…
- Google Sheets Text: What Cells Can Store and DoYes. Google Sheets can store text in cells, including words, numbers treated as text, symbols, and combinations such as product codes or…
- Google Sheets Unix Timestamp to Date Conversion GuideTo convert a Unix timestamp in Google Sheets, divide seconds by 86,400 or milliseconds by 86,400,000, then add the result to the…
- Google Sheets Conditional Formatting With VLOOKUP RulesYes. In Google Sheets, use Format > Conditional formatting, choose Custom formula is, and enter a formula that uses VLOOKUP to return…
- Google Sheets Conditional Formatting Range: How to Set ItIn Google Sheets, a conditional formatting range is the cell or group of cells a rule is allowed to format. Set it…
- Google Sheets Conditional Formatting With IFYes. In Google Sheets, use Format > Conditional formatting, choose Custom formula is, and enter a formula that evaluates to TRUE or…
- Google Sheets Conditional Formatting on Your PhoneYes—Google Sheets conditional formatting can be used on a phone, though the available controls depend on your device. The Android app supports…
- Google Sheets Conditional Formatting If True: How It WorksYes. In Google Sheets, conditional formatting applies a style when a cell meets a selected condition; for more flexible rules, choose Format…
- Google Sheets Conditional Formatting for Data TablesYes. In Google Sheets, you can apply conditional formatting to cells in a table by selecting its range and choosing Format >…
- Google Sheets Conditional Formatting for Entire RowsTo highlight an entire row in Google Sheets, select the rows’ full data range, open Format > Conditional formatting, choose Custom formula…
- Google Sheets Conditional Formatting for Full RowsYes. In Google Sheets, you can use conditional formatting to highlight an entire row when a cell in that row meets a…
- Google Sheets Conditional Formatting: If-Then RulesIn Google Sheets, an if-then conditional formatting rule checks whether a condition is true and automatically changes a cell’s appearance when it…
- Google Sheets COUNTIF Conditional Formatting GuideTo use COUNTIF in Google Sheets conditional formatting, select the cells to format, open Format > Conditional formatting, choose Custom formula is,…
- Google Sheets Custom Conditional Formatting GuideYes. Google Sheets lets you create custom conditional formatting rules, including formula-based rules that automatically change cell colors or styles when your…
- Google Sheets Conditional Formatting for DatesTo highlight dates in Google Sheets, select the date cells, choose Format > Conditional formatting, and set a date rule such as…
- Google Sheets Conditional Formatting for CheckboxesYes—Google Sheets can use conditional formatting to change a cell’s appearance when a checkbox is checked, but the two features are set…
- Google Sheets: Conditional Formatting for DuplicatesYes. In Google Sheets, you can highlight duplicate values with a custom conditional-formatting rule: select the cells, choose Format > Conditional formatting,…
- Google Sheets Conditional Data Validation ExplainedYes. In Google Sheets, conditional data validation can use a custom formula to allow or reject an entry based on other cells;…
- Google Sheets: Combine Two Columns into OneYes. In Google Sheets, combine two columns row by row with a formula such as =A2&" "&B2, which joins the values in…
- Google Sheets: How to Combine Data From Two ColumnsYes. In Google Sheets, combine two columns row by row with the ampersand operator: if the values are in A2 and B2,…