How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Slicers for Multiple Tables: What WorksYes, an Excel slicer can control multiple PivotTables when they share a compatible PivotTable cache or use the same Data Model. A…
- Excel Slicers: Advanced Features and Smart TipsExcel slicers are clickable visual filters for Excel Tables and PivotTables: select the table or PivotTable, choose the relevant Insert Slicer command,…
- Excel Slicer Examples: PivotTables, Tables, and TipsExcel slicer examples include filtering a sales PivotTable by region, showing only selected products in an Excel table, or letting readers choose…
- Excel Slicer Formatting: Styles, Size, Layout, and UseIn Excel for Microsoft 365 on Windows, select a slicer to open its contextual Slicer tab, then use Slicer Styles to change…
- Excel Slicers: What They Do and How to Use ThemAn Excel slicer is a set of clickable buttons that filters a table or PivotTable by the values in one or more…
- Excel Slicers: How to Create and Use ThemTo create a slicer in Excel for Microsoft 365 on Windows, click inside a PivotTable and choose PivotTable Analyze > Insert Slicer,…
- Slicer Command in Excel: How to Add and Use ItIn Excel for Microsoft 365 on Windows, select a PivotTable and choose PivotTable Analyze > Insert Slicer. For a regular Excel table,…
- Excel Slicers: How to Add, Use, and Troubleshoot ThemAn Excel slicer is a set of clickable buttons that filters a table or PivotTable by selected values. In Excel for Microsoft…
- Circular References in Excel: Show and Find ThemTo show a circular reference in Excel for Microsoft 365 on Windows, select Formulas > Error Checking > Circular References. Choose a…
- Excel Text to Columns: Split Data Into Separate CellsTo separate text into columns in Excel for Microsoft 365 on Windows, select the cells, choose Data > Text to Columns, select…
- SharePoint Corrupted Excel File? Recovery StepsIf an Excel file in SharePoint seems corrupted, first avoid saving over it: download a copy, then use SharePoint’s Version history to…
- Scenario Manager in Excel: How It Works and When to Use ItScenario Manager in Excel is a What-If Analysis tool for saving different sets of input values and comparing how they affect formula…
- Scenario Manager in Excel: Meaning and How to Use ItScenario Manager in Excel is a What-If Analysis tool for saving and comparing different sets of input values. In Hindi, it can…
- Excel Scenario Manager: How to Create and Compare CasesIn Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Scenario Manager to save and compare different sets of…
- Scenario Manager and Data Tables in ExcelScenario Manager and Data Tables are Excel’s What-If Analysis tools for seeing how different inputs affect a formula. Use Scenario Manager to…
- Scatter Plot in Excel With 3 Variables: How to Make OneTo show three variables in an Excel scatter plot, use a Bubble chart: plot the first variable on the X axis, the…
- Scatter Plot in Excel With Two VariablesTo make a scatter plot in Excel with two variables, put each variable in its own numeric column, select both columns, then…
- Scatter Plot Excel: How to Label Every Point With NamesTo label every point in an Excel scatter plot with names, select the chart, choose Chart Design > Add Chart Element >…
- Scatter Plot in Excel: Show Multiple Variables ClearlyYes. In Excel for Microsoft 365 on Windows, a scatter plot can show several variables by plotting two numerical variables on the…
- Scatter Plot Excel: Customize Axes and ScaleTo customize a scatter plot axis in Excel for Microsoft 365 on Windows, select the chart, right-click the horizontal or vertical axis,…
- Row Grouping in Excel: Collapse and Expand RowsTo group rows in Excel for Microsoft 365 on Windows, select the row numbers you want to organize, then choose Data >…
- Scatter Plot Equation in Excel: Find, Read, and Use ItTo find a scatter plot equation in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Add…
- Resolving Circular References in ExcelTo resolve a circular reference in Excel, find the formula that refers to its own cell, directly or through other formulas, and…
- Repeat Print Area in Excel: Repeat Rows on Every PageTo repeat rows or columns on every printed page in Excel for Microsoft 365 on Windows, open Page Layout > Print Titles,…
- Remove Flash Fill in Excel: Clear Results or Turn It OffTo remove Flash Fill results, select the cells Excel filled and choose Home > Clear > Clear Contents, or press Delete on…
- Remove Text to Columns in Excel: Undo or Reverse ItTo remove the effect of Text to Columns in Excel, press Ctrl+Z immediately after completing the operation; on a Mac, press Command+Z.…
- Remove Duplicates in Excel: Data Tab StepsIn Excel for Microsoft 365 on Windows, select the data you want to clean, then go to Data > Remove Duplicates. Choose…
- Remove Duplicates in Excel: Shortcut and Safe StepsIn Excel for Microsoft 365 on Windows, select a cell in your data and press Alt+A, then M to open Remove Duplicates.…
- Remove Duplicates by Row in ExcelTo remove duplicate rows in Excel for Microsoft 365 on Windows, select the full data range, then choose Data > Remove Duplicates.…
- Remove Both Duplicates in Excel: Keep One or Remove All Rows?Excel’s Remove Duplicates command does not remove both copies of a repeated entry: it keeps the first matching record and deletes later…