Excel How-To Guides

Fix the “Merge and Center is greyed out in Excel” error with easy solutions for protected sheets, tables, shared workbooks, and more.

Learn how to create sparklines in Excel to visualize trends, track performance, and build cleaner dashboards with step-by-step formatting tips.

Learn how to create folders in bulk from an Excel list using batch files, Command Prompt, or PowerShell. A simple step-by-step guide for Windows users.

Learn how to disable the Research pane in Excel, stop Smart Lookup popups, and prevent Alt+Click from opening it in Excel 365, 2019, and 2016.

Learn how to use conditional formatting with multiple conditions in Excel to highlight data, apply rules, and improve reports using simple steps and formulas.

Learn 6 easy ways to insert the degree symbol (°) in Excel using shortcuts, formulas, and formatting for temperatures and angles.

Learn how to format phone numbers in Excel using custom formats, formulas, and Flash Fill. Fix leading zeros and clean messy data.

Stop Excel from printing extra blank pages with simple fixes for print area, page breaks, formatting, and scaling. Save paper and print only what you need.

Remove dashes in Excel quickly using Find & Replace, formulas, Flash Fill, and more. Learn simple methods to clean and format numbers without errors.

Merge Excel files with different columns safely using Power Query. Learn the simple step to include all fields and prevent missing data during consolidation.