How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- COUNTIF TRUE in Google Sheets: Count Boolean ValuesTo count cells whose value is the Boolean TRUE in Google Sheets, use =COUNTIF(A2:A20,TRUE), replacing A2:A20 with your range. This is especially…
- COUNTIF in Google Sheets: Syntax and ExamplesIn Google Sheets, COUNTIF counts cells in a range that meet one condition. With product names in A2:A20, for example, enter =COUNTIF(A2:A20,"Apple")…
- COUNTIF Google Sheets: Count Blank Cells and Empty StringsIn Google Sheets, use =COUNTIF(A2:A100,"") to count blank cells in A2:A100. The formula counts empty cells and cells whose formulas return an…
- COUNTIF in Google Sheets: Syntax, Examples, and TipsIn Google Sheets, COUNTIF counts cells that meet one condition. If A2:A6 contains Maya, Leo, Maya, Noor, and Maya, enter =COUNTIF(A2:A6,"Maya") to…
- COUNTIF Duplicate Formula in Google SheetsTo flag every nonblank value that appears more than once in Google Sheets, put this formula beside the first data row and…
- COUNTIF for Nonblank Cells in Google Sheets: TipsTo count cells that are not blank in Google Sheets, use =COUNTIF(A2:A100,"<>"). Replace A2:A100 with your range; the criterion "<>" means “not…
- COUNTIF Dropdown in Google Sheets: Count SelectionsTo count choices made in a Google Sheets dropdown, use COUNTIF on the cells containing the dropdowns. For example, if B2:B100 contains…
- Count Unique in Google Sheets: Formulas and ExamplesTo count distinct values in Google Sheets, use =COUNTUNIQUE(A2:A100) when the values are in cells A2 through A100. The function returns one…
- Count Cells With Text in Google Sheets: Formulas and TipsTo count cells containing text in Google Sheets, use =COUNTIF(A2:A100,"*"), replacing the range with your data. For a more precise count that…
- COUNTIF Blank in Google Sheets: Count Empty CellsTo count blank cells in Google Sheets, use =COUNTIF(A2:A100,""); this counts empty cells in the specified range, including cells whose formulas return…
- How to Count Dropdown Values in Google SheetsTo count a particular dropdown choice in Google Sheets, use COUNTIF: if the dropdown answers are in B2:B100, enter =COUNTIF(B2:B100,"Approved") to count…
- Count Checkboxes in Google Sheets with COUNTIFTo count checked checkboxes in Google Sheets, use COUNTIF with TRUE as the criterion. If the checkboxes are in B2:B100, enter =COUNTIF(B2:B100,TRUE)…
- Google Sheets Dropdown Chips: How to Convert ThemTo convert an existing Google Sheets dropdown into a chip, select a cell in the dropdown, open Data > Data validation, edit…
- Copy a Dropdown in Google Sheets: Steps and FixesTo copy a dropdown in Google Sheets, copy the cell that contains it, select the destination cell, and paste. To copy only…
- Convert to Dropdown in Google Sheets: Setup and TipsTo convert cells to a dropdown in Google Sheets, select the cells, choose Insert > Dropdown, add the choices, and click Done.…
- Conditional Formatting in Excel and Google Sheets GuideConditional formatting changes a cell’s appearance automatically when its value meets a rule. In Excel for Microsoft 365, select the cells and…
- Google Sheets Conditional Formatting Rules ExplainedIn Google Sheets, conditional formatting rules automatically change a cell’s appearance when its value meets a condition. Select the cells, choose Format…
- Google Sheets: Conditional Formatting for Tick BoxesYes. In Google Sheets, you can use conditional formatting to change a checkbox’s appearance or highlight other cells when it is checked.…
- Google Sheets Custom Conditional Formatting: A GuideYes. In Google Sheets, custom conditional formatting lets you apply a style when a formula evaluates to TRUE: select a range, open…
- Conditional Dropdowns in Google Sheets: How They WorkTo make a conditional (dependent) dropdown in Google Sheets, create a named range for each group of choices, then set the second…
- Google Sheets Conditional Formatting: Rules and ExamplesIn Google Sheets, select the cells you want to format, then choose Format > Conditional formatting to create a rule that changes…
- Compress Pictures in PowerPoint Office 365 to Save SpaceTo compress pictures in PowerPoint for Microsoft 365 on Windows, select a picture, then choose Picture Format > Compress Pictures. In the…
- Compressing Pictures in PowerPoint: Settings and StepsTo compress pictures in PowerPoint for Microsoft 365 on Windows, select a picture, go to Picture Format > Compress Pictures, choose whether…
- Color Duplicates in Google Sheets: Conditional FormattingTo color duplicate values in Google Sheets, select the cells, open Format > Conditional formatting, choose Custom formula is, and enter a…
- Combine Two Columns in Google Sheets: Formulas and MoreTo combine the contents of two columns into one, enter a formula such as =A2&" "&B2 in an empty cell, then fill…
- Google Sheets Merge Cells Command and How to Use ItTo merge cells in Google Sheets, select the cells, then choose Format > Merge cells > Merge all. You can also use…
- Clear Outlook Roam Cache: Safe Steps and What ChangesTo clear Outlook’s Auto-Complete suggestions, open classic Outlook for Windows and select File > Options > Mail > Empty Auto-Complete List, then…
- Clear Outlook Global Address List Cache in OutlookTo clear the Global Address List (GAL) cache in classic Outlook for Windows, open Send/Receive > Send/Receive Groups > Download Address Book,…
- How to Clear the Outlook GAL CacheTo refresh the Global Address List (GAL) cache in classic Outlook for Microsoft 365 on Windows, select Send/Receive > Send/Receive Groups >…
- Clear Outlook User Cache: What to Delete and When to Do ItTo clear the Outlook user cache, first identify which cache is causing the problem: in classic Outlook for Windows, use File >…