How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Analysis ToolPak in Excel: What It Does and How to Enable ItIf you mean Excel’s Analysis ToolPak, it is a Microsoft Excel add-in that provides statistical and engineering analysis tools, including descriptive statistics,…
- Analysis Report in Excel: How to Build a Useful ReportTo make an analysis report in Excel, organize clean records in a table, summarize them with a PivotTable or formulas, add charts…
- Analysis Tab in Excel: Where It Is and What It DoesExcel does not have one permanent ribbon tab simply called “Analysis.” If you mean the PivotTable Analyze tab, click inside a PivotTable…
- Analysis Group in Excel: Where It Is and How to Use ItIn Excel for Microsoft 365 on Windows, the Analysis group is on the Data tab when the relevant add-ins are enabled. It…
- Excel Analysis ToolPak: Setup, Uses, and LimitationsExcel’s Analysis ToolPak is a built-in add-in for statistical and engineering analyses, including descriptive statistics, regression, and histograms. In Excel for Microsoft…
- Excel Circle Bullets: How to Add, Format, and Align ThemTo add a circle bullet in Excel for Microsoft 365 on Windows, select a cell, choose Insert > Symbol > Symbol, and…
- 4-Segment Circle in Excel: How to Make OneTo make a circle with four segments in Excel, enter four categories and four positive values, select the data, then choose Insert…
- Excel Enum Cell: What It Means and How to Create OneExcel does not have a native “enum cell” type: a worksheet cell cannot be assigned a fixed set of allowed values in…
- Human Body in Excel: Create a Diagram Step by StepTo create a simple human body diagram in Excel, use Insert > Shapes to combine an oval for the head, a rounded…
- How to Create a Concentric Circle Diagram in Excel FastTo make a concentric circle diagram in Excel, insert several oval shapes, size each one smaller than the last, and use the…
- Why Is Flash Fill Greyed Out in Excel?Flash Fill is usually greyed out because Excel cannot use it in the current app or selection, or because Flash Fill has…
- Why Is My Excel File Corrupted? Causes and FixesAn Excel file is usually described as corrupted when Excel cannot read its contents reliably, or when part of the workbook has…
- Why Can’t I Hyperlink in Excel? Common Causes and FixesYou usually can’t hyperlink in Excel because the cell or sheet is not editable, Excel is treating the entry as text, automatic…
- Why Use Scenario Manager in Excel? Compare OutcomesWe use Scenario Manager in Excel to save different sets of input values and compare how each set changes the results of…
- Why Can’t I Add a Hyperlink in Excel? Common FixesYou usually can’t add a hyperlink in Excel because the worksheet is protected, the workbook is not editable, or Excel is in…
- Which Excel Line Is Corrupted? How to Find ItNo specific line can be identified because no Excel file was provided. If you upload the workbook, the suspect row can be…
- Flash Fill in Excel: Purpose, Examples, and LimitsFlash Fill in Excel recognizes a pattern in data you enter and fills the remaining cells to match it. For example, type…
- Yearly Slicer in Excel: What It Means and How to Set One UpA yearly slicer in Excel is a slicer that lets people filter a PivotTable or connected report by year. It is not…
- How to Verify an Excel File Has Not Been CorruptedExcel has no single command that proves a workbook is completely uncorrupted. To check a file, make a copy, open it in…
- Vertical Scatter Plot in Excel: How to Create OneTo make a vertical scatter plot in Excel, put the same X value beside each observation, select the X and Y columns,…
- Unlock an Excel Slicer: Steps, Protection, and FixesTo unlock an Excel slicer, first unprotect its worksheet if necessary, then right-click the slicer and choose Size and Properties > Properties;…
- Excel File Could Be Corrupted or Unsafe? What to DoYes, an Excel file can be corrupted, unsafe, both, or neither: the warning alone does not prove which. If Excel says the…
- State Heat Map in Excel: Create, Format, and TroubleshootTo make a U.S. state heat map in Excel for Microsoft 365 on Windows, put each state and its numeric value in…
- Stop Flash Fill in Excel: Turn Off Automatic FillingTo stop a Flash Fill that just happened, press Ctrl+Z in Excel for Windows. To prevent automatic Flash Fill suggestions in the…
- Supply Chain Management Excel Solver: A Practical GuideYes. Microsoft Excel’s Solver add-in can optimize a supply chain model by choosing shipment, production, or inventory quantities to minimize cost or…
- Split Text to Columns in Excel: A Practical GuideTo split text into separate Excel columns, select the source cells, then choose Data > Text to Columns. In the wizard, choose…
- Split Text to Columns in Excel Online: Steps and FixesYes. In Excel for the web, select the cells you want to split, choose Data > Text to Columns, select the delimiter…
- Split Cell Colour in Excel: Methods and LimitationsExcel cannot split one cell into two independently coloured halves using a built-in cell-fill setting. To show two colours in a single…
- Excel Solver: Setup, Optimization Models, and FixesExcel has a Solver add-in, but there is no standard Excel feature formally called a “Solver block.” Solver helps find values for…
- Solver in Excel: Where to Find It and How to Enable ItIn Excel for Microsoft 365 on Windows, find Solver on the Data tab, in the Analysis group. If it is not there,…