Excel How-To Guides

Learn how to sum a column based on another column value in Excel using SUMIF, SUMIFS, and simple formulas with clear, practical examples.

Learn how to combine two columns in Excel using &, CONCAT, TEXTJOIN, and Flash Fill. Follow simple step by step methods to merge data quickly and accurately.

Fix Excel freezing when printing with these easy steps. Update drivers, disable add-ins, repair Office, and more. Get your spreadsheets printing again fast.

Learn how to create a button in Excel with step-by-step instructions, macros, Form Controls, shapes, and VBA automation tips.

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.