Excel How-To Guides

Learn how to make a bell curve in Excel with NORM.DIST and a smooth scatter chart, from a known mean and standard deviation or from your own data.

Learn how to write scientific notation in Excel by typing E, using the Scientific format, a custom engineering format, or the TEXT function.

Move columns in Excel without overwriting data using Shift + drag, Insert Cut Cells, a left-to-right sort, or the CHOOSECOLS function.

Unprotect an Excel sheet or workbook with the password, or remove protection without it using the ZIP and XML trick or Google Sheets.

Move an Excel chart to its own chart sheet, to another worksheet, or to a new worksheet using the Move Chart dialog or cut and paste.

Split text in one Excel cell into separate rows with TEXTSPLIT, Power Query, or Text to Columns plus Transpose. Step-by-step examples with screenshots.

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.