How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Duplicate Filter in Google Sheets: Find Repeated RowsTo filter duplicates in Google Sheets, add a helper column with a COUNTIF formula, then filter that column to show TRUE. For…
- Double Space Shortcut in Word: Windows and MacIn Microsoft Word for Windows, press Ctrl+2 to double-space the selected text or the paragraph where the cursor is placed. On a…
- Dropdown Menu in Google Sheets: Create and Manage ListsTo create a dropdown menu in Google Sheets in a browser, select the cell or cells, choose Insert > Dropdown, add the…
- Google Sheets Dropdown Formula: How It Really WorksGoogle Sheets does not create a dropdown with a standalone cell formula: use Data validation to make the dropdown, and use a…
- Excel Dropdown Like Google Sheets? Create One EasilyYes. Excel can make a dropdown much like Google Sheets: select the cells, go to Data > Data Validation, choose List, and…
- Double Space in Word: Set 2.0 Line SpacingIn Microsoft Word, double spacing means setting line spacing to 2.0; it does not change the number of words in a document.…
- Dotted Line in Excel and Word: How to Add OneTo add a dotted line at the bottom of a cell or selected range in Excel, select it, open Home > Borders…
- XLOOKUP in Google Sheets: How It Works and When to Use ItYes. XLOOKUP is a built-in Google Sheets function that searches a row or column for a value and returns a related value…
- Does SUMIF Work in Google Sheets? Syntax and ExamplesYes. SUMIF works in Google Sheets and adds values that meet one condition, such as totaling expenses labeled “Travel” or sales above…
- INDEX MATCH in Google Sheets: How It Works and ExamplesYes. Google Sheets supports both INDEX and MATCH, and combining them lets you find a value in one range and return a…
- Does Google Sheets Have VLOOKUP? How to Use ItYes. Google Sheets has the VLOOKUP function, which searches down the first column of a range and returns a value from another…
- Does Google Sheets Have XLOOKUP? How to Use ItYes. Google Sheets has a built-in XLOOKUP function that finds a value in one range and returns the corresponding value from another.…
- Google Sheets SUMIFS: How It Works and ExamplesYes. Google Sheets has a built-in SUMIFS function that adds numbers only when multiple conditions are met, such as summing sales for…
- Does Google Sheets Have Power Query? What to Use InsteadNo. Google Sheets does not include Power Query, Microsoft Excel’s built-in tool for importing, cleaning, combining, and refreshing data. Sheets does offer…
- Does Block Sender in Outlook Really Work? What to KnowYes—Outlook’s Block Sender feature works by directing future email from a blocked address to Junk Email, rather than reliably stopping the sender…
- Google Docs and Google Sheets: Differences and UsesGoogle Docs is Google’s word-processing app for writing and formatting documents; Google Sheets is its spreadsheet app for organizing data, calculations, and…
- Diagonal Split Cell in Google Sheets: What Works?Google Sheets does not have a built-in diagonal cell border or a command to split one cell into two triangular sections. To…
- Excel vs. Google Sheets: Key Differences ExplainedMicrosoft Excel is generally stronger for advanced analysis, large or complex workbooks, and specialist business features; Google Sheets is generally simpler for…
- Dependent Dropdowns in Google Sheets: Setup and FixesTo make a dependent dropdown in Google Sheets, create a named range for each group of choices, then set the second dropdown’s…
- Detect Duplicates in Google Sheets: A Practical GuideTo detect duplicates in Google Sheets, select the cells you want to check, choose Format > Conditional formatting, and use a custom…
- Dependent Dropdowns in Google Sheets: How to Set Them UpTo create a dependent dropdown in Google Sheets, make a named range for each set of choices, then use =INDIRECT($A2) as the…
- Delete an Unwanted Page in Word: Simple FixesTo delete an unwanted page in Word, remove the text or objects on it, or delete the page break or other formatting…
- How to Delete an Unwanted Page in WordTo delete an unwanted page in Microsoft Word for Microsoft 365 on Windows, press Ctrl+G, type \page in the page-number box, press…
- Delete an Unused Page in Word: Causes and Easy FixesTo delete an unused page in Microsoft Word, show formatting marks with Ctrl+Shift+8, then remove the extra paragraph marks or page break…
- How to Delete a Filter View in Google SheetsTo delete a filter view in Google Sheets, open the spreadsheet in a web browser, go to Data > Change view, and…
- Delete a Scheduled Email in OutlookYes. In new Outlook or Outlook on the web, open the scheduled message in Drafts, choose Cancel send, then delete the message…
- Delete Duplicates in Google Sheets: Safe MethodsTo delete duplicate rows in Google Sheets, select your data, then choose Data > Data cleanup > Remove duplicates. Confirm whether the…
- Debt Snowball Spreadsheet in Google Sheets: How to Make OneYes—you can make a debt snowball spreadsheet in Google Sheets by listing each debt, sorting by balance from smallest to largest, and…
- Debt Snowball Spreadsheet for Google Sheets: Setup & FormulasYes. A debt snowball spreadsheet for Google Sheets can rank debts by current balance, apply minimum payments to every account, then direct…
- Date Formula in Google Sheets: Dates, Days, and UsesThe basic date formula in Google Sheets is =DATE(year, month, day). For example, with the year, month, and day entered as numbers…