How to Run CHKDSK in Windows 11
Run CHKDSK in Windows 11 from File Explorer, Terminal or Windows RE. Learn which switch to use, when /r is risky, SSD tips and how to...
Browse help by platform
- Windows Settings, updates, files, networking and fixes for Windows 11 and 10. Browse guides
- Microsoft Office Excel formulas, Word formatting, PowerPoint and Outlook how-tos. Browse guides
- Apple iPhone, iPad, Mac and Apple Watch settings and features. Browse guides
- Google Docs, Sheets, Slides, Gmail, Chrome and Drive tutorials. Browse guides
- Android Phone settings, apps and troubleshooting for Android devices. Browse guides
- Streaming Set up and fix Roku, Fire TV, Netflix, YouTube and more. Browse guides
New guides
How to Use IFERROR in Excel
Learn how to use IFERROR in Excel to replace #DIV/0! and #N/A errors with text, a blank or 0, plus when IFNA or XLOOKUP is the...
Popular topics
Excel227 guides
- How to Use IFERROR in Excel
- How to Print Gridlines in Excel
- How to Transpose Data in Excel
- Sum a Column in Excel That Gets Filtered or Keeps Growing
- How to Lock Cells and Protect a Sheet in Excel
- Color Excel Cells Automatically With Conditional Formatting
Recently published
How to Rename Multiple Files at Once in Windows 11
Rename multiple files at once in Windows 11 with File Explorer, PowerToys PowerRename, PowerShell with a -WhatIf preview, or Command Prompt ren.
Keep Header Rows Visible While Scrolling in Google Sheets
Freeze rows in Google Sheets with View > Freeze, the gray drag bar or the right-click menu, plus steps for the Android and iPhone apps and how to unfreeze.
How to Superscript and Subscript in Word
Superscript or subscript in Word with the Home tab buttons, keyboard shortcuts (including the new subscript shortcut), the Font dialog, or symbols.
How to Calibrate Your Monitor in Windows 11
Calibrate your monitor in Windows 11 with Display Color Calibration or the Windows HDR Calibration app, and learn when a hardware colorimeter is worth it.
How to Double Space in Google Docs
Double space in Google Docs from the toolbar or Format menu, make it your default style, or set it in the iPhone, iPad and Android app. Fixes included.
How to Transpose Data in Excel
Transpose data in Excel with Paste Special, the TRANSPOSE function or Power Query, for Microsoft 365 and older versions, plus fixes for common errors.
How to Find Your Windows 11 Product Key
Find your Windows 11 product key with PowerShell, a sticker or your purchase email, check for a digital license, and see why the wmic command fails.
Check Your iPhone iCloud Backup and Fix It When It Fails
Back up your iPhone to iCloud in iOS 27 or iOS 26: turn on iCloud Backup, use Back Up Now, confirm it worked, and fix not enough storage errors.
How to Insert a PDF into Word
Insert a PDF into Word as an embedded object or icon, as editable text with PDF reflow or Text from File, or as page images, on Windows and Mac.
How to Set Up Windows Hello Face Recognition in Windows 11
Set up Windows Hello face recognition in Windows 11, check for the IR camera it needs, and fix face sign-in when it's unavailable or can't recognize you.
How to Free Up iCloud Storage
Free up iCloud storage on iPhone: find what's using space, delete old backups, photos, iCloud Drive files and Messages attachments, and know what you lose.
Sum a Column in Excel That Gets Filtered or Keeps Growing
Learn how to sum a column in Excel with AutoSum, the SUM function, the status bar or a table Total Row, plus how to total only filtered or matching rows.
How to Uninstall an Update in Windows 11
Uninstall an update in Windows 11 from Settings, a command, or the recovery menu if Windows won't start, plus what to do when an update can't be removed.
How to Turn Off Autocorrect on iPhone
Turn off autocorrect on iPhone in Settings > General > Keyboard, or keep it on and fix bad corrections with Text Replacement or a dictionary reset.
How to Insert a Text Box in Word
Insert a text box in Word with Insert > Text Box or Draw Text Box, then wrap text around it, change the border, link boxes, and add one on Mac...
Turn Off the Windows 11 Firewall Safely, Then Back On
Turn off the firewall in Windows 11 from Windows Security, Control Panel or a command, allow one app instead, and turn the firewall back on safely.
How to Recover Recently Deleted Photos on iPhone
Recover recently deleted photos on iPhone in iOS 26 from Recently Deleted, iCloud.com or a backup, plus what to try once the 30-day window has passed.
How to Lock Cells and Protect a Sheet in Excel
Lock cells in Excel by unlocking the cells people fill in, then turning on Review > Protect Sheet. Covers formulas, passwords, edit ranges, Mac and web.
How to Turn On Mobile Hotspot in Windows 11
Turn on Mobile hotspot in Windows 11 from Settings or Quick Settings, change the hotspot name and password, connect devices, and fix a grayed-out switch.
How to Hide Photos on iPhone
Hide photos on iPhone in iOS 26 and iOS 27: use Hide in Photos, open the locked Hidden album, unhide pictures, and remove the album from view.
How to Make Columns in Word
Make columns in Word with Layout > Columns: two or three columns, columns for part of a page, column breaks, a line between, and fixes on Mac and web.
How to Turn On Night Light in Windows 11
Turn on Night light in Windows 11 from Settings or Quick Settings, adjust its strength, set a sunset-to-sunrise schedule, and fix a grayed-out toggle.
Block a Sender or Whole Domain in Outlook, and Undo It
Block a sender in Outlook with steps for new Outlook, classic Outlook, Outlook.com and the phone app, plus how to block a domain and unblock someone.
Color Excel Cells Automatically With Conditional Formatting
Learn how to use conditional formatting in Excel with built-in rules, data bars, color scales, formula rules you can copy, and fixes for common problems.
How to Use Virtual Desktops in Windows 11
Learn how to use virtual desktops in Windows 11: create, switch, rename and close desktops, move apps between them, and fix shortcuts that don't work.
How to Create a Contact Group in Outlook
Create a contact group in new Outlook, classic Outlook or Outlook on the web, email it, edit or delete it, and see when a Microsoft 365 group fits better.
How to Insert a Checkbox in Word
Insert a checkbox in Word: clickable boxes from the Developer tab, printable box bullets, checkbox symbols and web checklists on Windows and Mac.
No Sound on Windows 11? Match the Symptom to the Fix
Fix no sound in Windows 11: pick the right output device, check the Volume mixer, run the audio troubleshooter, and update or roll back the audio driver.
Share Your Outlook Calendar With Coworkers or Gmail Users
Share your calendar in new Outlook, classic Outlook, Outlook on the web or Outlook.com, publish an ICS link, and pick the right permission level.
How to Use INDEX and MATCH in Excel
Learn how to use INDEX and MATCH in Excel with step-by-step examples, two-way and multiple-criteria lookups, and fixes for #N/A and wrong results.
How to Fix Wi-Fi Not Working in Windows 11
Fix Wi-Fi not working in Windows 11 with quick checks, the network troubleshooter, driver and power fixes, network commands, and network reset.
How to Create Rules in Outlook
Create rules in Outlook to sort email automatically, with steps for new Outlook, classic Outlook and the web, plus server vs. client-only rules.
How to Insert Footnotes in Word
Learn how to insert footnotes in Word on Windows, Mac, the web and mobile, plus how to change numbering, convert to endnotes and delete footnotes.
How to Fix 100% Disk Usage in Windows 11
Fix 100% disk usage in Windows 11: find the cause in Task Manager, then use safe Microsoft-documented fixes for Search, SysMain, updates and drive errors.
Schedule Send or Delay Delivery in Every Outlook App
Schedule an email in Outlook with Schedule send in new Outlook, the web or mobile, or Delay Delivery in classic Outlook, plus how to edit or cancel it.
How to Use COUNTIF in Excel
Learn how to use COUNTIF in Excel with examples for text, numbers, dates and wildcards, plus COUNTIFS, OR logic and fixes when COUNTIF returns 0.
How to Use Phone Link in Windows 11
Set up Phone Link in Windows 11 with an Android phone or iPhone, then text, call and see notifications on your PC. Includes what works on each phone.
When Outlook Can Recall an Email, and Plan B When It Can’t
Recall an email in new or classic Outlook, on the web, Mac or phone. See which accounts support recall, how cloud recall works, and how to read the report.
How to Do a Hanging Indent in Word
Learn how to do a hanging indent in Word with Ctrl+T, the Paragraph dialog or the ruler on Windows, Mac and the web, plus fixes for indents that break.
How to Use Storage Sense in Windows 11
Learn how to turn on Storage Sense in Windows 11, choose what it deletes and when, free up OneDrive space, run it now, and fix common problems.
How to Set Up Automatic Replies (Out of Office) in Outlook
Set up automatic replies (out of office) in new Outlook, classic Outlook and Outlook on the web, plus a rule for Gmail or IMAP accounts and fixes.
Test Unknown Files Safely in Windows Sandbox on Windows 11
Turn on Windows Sandbox in Windows 11 from Settings, Windows Features or PowerShell, test apps safely, lock it down with a .wsb file, and fix errors.