How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Multiple Text to Columns in Excel: Methods That WorkIn Excel for Microsoft 365 on Windows, Text to Columns is best treated as a one-source-column tool: select a single column, then…
- Excel Split Cell Into Columns: Methods and TipsYes. In Excel for Microsoft 365 on Windows, select the cells, then choose Data > Text to Columns and follow the wizard…
- Excel Set Print Area: Steps, Tips, and FixesTo set a print area in Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page…
- MS Excel Solver: How It Works, Setup, and When to Use ItMicrosoft Excel Solver is an optimization add-in that finds values for selected cells to maximize, minimize, or reach a target result while…
- Excel: Split a Cell by Hyphen in 4 WaysYes. In Excel for Microsoft 365 on Windows, select the cells, then choose Data > Text to Columns > Delimited, select Other,…
- Excel Remove Duplicates from a Column: What to KnowTo remove duplicates from a column in Microsoft Excel for Microsoft 365 on Windows, select the column or the full data range,…
- Excel Remove Print Area: Clear It Without Deleting DataTo remove a print area in Excel for Microsoft 365 on Windows, select the worksheet, go to Page Layout > Print Area…
- Excel Protect Sheet: How to Lock Cells and Set PermissionsTo protect a worksheet in Microsoft Excel for Microsoft 365 on Windows, open the sheet, choose Review > Protect Sheet, select the…
- Excel Protect Sheet: Allow Editing in Selected CellsYes. In Excel for Microsoft 365, select the cells people should be able to change, clear their Locked setting, and then choose…
- Excel Heat Maps: How to Create, Format, and Read ThemIn Microsoft Excel for Microsoft 365 on Windows, create a heat map by selecting a numeric range and choosing Home > Conditional…
- Excel Group Rows: How to Collapse and Expand DataYes. In Excel for Microsoft 365 on Windows, select the row headers you want to group, then choose Data > Outline >…
- Excel Named Range: What It Is and How to Use ItAn Excel named range is a descriptive name assigned to a cell, a group of cells, or a formula, so you can…
- Excel Goal Seek: How to Find the Input Value You NeedIn Microsoft Excel for Microsoft 365 on Windows, use Data > What-If Analysis > Goal Seek to find the input that makes…
- Excel Data Table: How It Works and When to Use OneAn Excel Data Table is a What-If Analysis tool that recalculates a formula for a range of one or two changing input…
- Compare Two Sheets in Excel: Methods That WorkTo compare cells in the same positions, put this formula in a third sheet; with the values to compare in Sheet1!A1 and…
- Excel Named Range: How to Create and Use OneTo create a named range in Microsoft Excel for Microsoft 365 on Windows, select the cell or range, click the Name Box…
- Merge Cell Rows in Excel: Steps, Limits, and AlternativesTo merge cells across rows in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Merge & Center…
- Merge Cells Button in Excel: Where It Is and How to Use ItIn Excel for Microsoft 365 on Windows, find the Merge Cells button on the Home tab, in the Alignment group: select the…
- Move Text From Columns to Rows in Excel: Best MethodsTo turn a vertical range into a horizontal row in Excel, copy the cells, select an empty destination, then choose Home >…
- Excel Not Responding: Causes, Fixes, and What to TryIf Excel says “Not Responding,” first wait a few minutes, especially if the workbook is large or Excel is calculating; then try…
- Marked Scatter Plot in Excel: Create and Format OneTo make a marked scatter plot in Excel for Microsoft 365 on Windows, select the cells containing your numeric X and Y…
- Matrices in Excel Solver: When It Helps and When It Doesn’tYes—but Excel Solver is not a dedicated matrix-equation solver. For a square linear system, use Excel’s MINVERSE and MMULT functions; use Solver…
- Lock a Slicer in Excel: Keep It in Place and UsableTo let people use an Excel slicer on a protected worksheet, right-click the slicer, choose Size and Properties, open Properties, and clear…
- Location Heat Map in Excel: How to Build OneYou can make a location heat map in Excel for Microsoft 365 on Windows with 3D Maps: put location fields and a…
- Excel Lookup Remove Duplicates: What Works and WhyNo—an Excel lookup does not remove duplicate records; it finds and returns a matching value. To delete duplicates from a list, select…
- Load Query Data into an Excel Table: A Practical GuideTo load Power Query data into an Excel table in Microsoft 365 for Windows, open the query in Power Query Editor, select…
- Load Excel Data Into a SQL Table: A Practical GuideTo load Excel data into a SQL table, first clean and check the worksheet, then import it with your database’s import wizard…
- Load Excel Power Query Into an Existing TableIn Excel for Microsoft 365 on Windows, a Power Query can load to an existing worksheet, but it generally cannot use an…
- Linear Programming Excel Solver Template: Build and Use OneA linear programming Excel Solver template is a worksheet with decision-variable cells, formulas for the objective and resource use, and constraints that…
- Link Excel Data to a PowerPoint Table and Keep It UpdatedYes. In PowerPoint for Microsoft 365 on Windows, copy the cells in Excel, then choose Home > Paste > Paste Special, select…