How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Solver: How to Save and Reuse Solver ScenariosYes. After Solver finds a solution in Excel for Microsoft 365 on Windows, choose Save Scenario in the Solver Results dialog, give…
- Excel Solver Not Installed? How to Enable ItIf Solver seems not installed in Excel for Microsoft 365 on Windows, it is usually present but not enabled. Go to File…
- Excel Solver Not Responding? Fixes and CausesIf Excel Solver is not responding, first give it a moment: Solver may be calculating a difficult model rather than being stuck.…
- Excel Solver: Whole Numbers, Integers, and ConstraintsNo. In Excel, Solver can use decimal values by default; it uses whole numbers only when you add an integer constraint to…
- Excel Solver Not Finding a Solution? Troubleshoot ItIf Excel Solver is not finding a solution, first check that the objective cell depends on the changing cells, the constraints are…
- Excel Solver Limitations: What It Can and Cannot DoExcel Solver is best suited to small, well-structured optimization models: the standard Solver add-in can adjust at most 200 variable cells, and…
- Excel Solver for Linear Programming: Setup and LimitsYes—Excel Solver can solve linear programming (LP) models in desktop Excel for Microsoft 365 on Windows. Put the objective and constraint calculations…
- Excel Solver: How to Add Parameters and ConstraintsTo add parameters in Excel Solver, open Data > Solver, choose the objective cell and the changing variable cells, then select Add…
- Excel Solver for Beginners: Set Up Your First ModelExcel Solver finds values for selected cells that maximize, minimize, or reach a target in a formula, while obeying limits you specify.…
- Excel Solver for Resource Allocation: A Practical GuideYes. Excel Solver can allocate limited resources by choosing values for decision cells that maximize an objective, such as profit or output,…
- Excel Solver: How to Add Constraints and Set LimitsTo add constraints in Excel Solver, open Data > Solver, enter your objective and changing cells, then select Add under Subject to…
- Excel Solver: How to Add an Objective CellTo add an objective in Excel Solver, open Data > Solver, enter the single cell you want to optimize in Set Objective,…
- Excel Solver Add-In Not Showing in Ribbon? FixesIf the Solver button is missing from Excel’s ribbon, first enable the built-in add-in: go to File > Options > Add-ins, choose…
- Excel Slicer Video: How to Add, Use, and TroubleshootIf you’re looking for an Excel slicer video, search Microsoft’s Excel help and training resources for slicer tutorials; a useful demonstration should…
- Excel Slicer Tool: How to Add, Use, and Customize ItThe Excel slicer tool is a visual filter: it adds clickable buttons that let you show selected categories in an Excel table…
- Excel Slicer Slider: Range Filters and AlternativesNo—Excel’s standard slicers do not have a slider for choosing a continuous numeric range. For dates, a PivotTable Timeline provides a draggable…
- Excel Slicer Range: What It Filters and How to Change ItAn Excel slicer does not have a separate worksheet-cell range that you can assign to it: it filters a field in an…
- Excel Slicer: Remove Old Values and Stale ItemsTo remove deleted values from a PivotTable slicer in Excel for Microsoft 365 on Windows, set the PivotTable cache to retain no…
- Excel Slicer No Connections Found? Causes and FixesIf Excel says “No connections found” when you open a slicer’s Report Connections, it usually means there are no other compatible PivotTables…
- Excel Slicer Not Updating? Fixes for PivotTables and TablesIf an Excel slicer is not updating, first refresh the PivotTable or source data, then check that the slicer is connected to…
- Excel Slicer Horizontal: How to Arrange Buttons in RowsTo make an Excel slicer horizontal, select it and increase the Columns setting on the contextual Slicer tab. Excel lays the slicer…
- Excel Slicer Multiple Columns: What Works and What Doesn’tCan one Excel slicer filter multiple columns? Not directly: a slicer is attached to one field at a time. You can add…
- Excel Slicer Multiple Selections: How to Use ThemYes. In Excel for Microsoft 365 on Windows, you can select several items in one slicer by clicking its Multi-Select button and…
- Excel Slicer Formatting: Styles, Colors, and LayoutTo format an Excel slicer in Microsoft 365 for Windows, select it, open the contextual Slicer tab, and choose a built-in style…
- Excel Slicer Greyed Out? Causes and FixesIf Excel’s Insert Slicer command is greyed out, first select a cell inside an Excel Table or PivotTable; slicers cannot be added…
- Excel Slicer: How to Hide Blank ItemsYes, you can hide blank entries from an Excel slicer in some cases: select the slicer, open Slicer > Slicer Settings, and…
- Excel Slicer Connections: Link One Slicer to PivotsExcel slicer connections determine which PivotTables respond when you click a slicer. In Excel for Microsoft 365 on Windows, select the slicer,…
- Excel Slicer by Month: Set Up and Troubleshoot Date FiltersYes. To filter an Excel PivotTable by month, group its date field by Months and Years, then add a slicer for the…
- Excel Slicer: How to Change Its Data SourceIn Excel for Microsoft 365 on Windows, a slicer has no independent “change data source” command: change the source of the PivotTable…
- Excel Slicer: Change Font, Size, and Style in ExcelTo change an Excel slicer’s font, select the slicer, open the Slicer tab, and create or modify a slicer style; in that…