How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Slicer as a Dropdown: Options and WorkaroundsNo: in Excel for Microsoft 365 on Windows, you cannot turn a slicer into a conventional dropdown menu. A slicer filters a…
- Excel Sheet Not Responding? Causes and Safe Fixes GuideIf Excel says Not Responding, first give it a few minutes if it may be calculating, refreshing data, or opening a large…
- Excel Show Print Area Lines: View Page BoundariesTo see where Excel’s printed pages end, choose View > Page Break Preview; the blue lines show page boundaries, and the gray…
- Excel Print Area Based on Cell Value: How to Set ItExcel cannot make the Print Area box follow a cell value by itself. To set a print area that changes with a…
- Excel Select Named Range: Every Useful MethodIn Excel for Microsoft 365 on Windows, select a named range by clicking the Name Box to the left of the formula…
- Excel Set Print Area Greyed Out? Causes and FixesIn Excel for Microsoft 365 on Windows, Set Print Area is usually greyed out because Excel is not in a normal worksheet-selection…
- Excel Scatter Plots: Create, Format, and Interpret ThemAn Excel scatter plot shows the relationship between two sets of numerical values: one variable on the horizontal X-axis and another on…
- Excel Searchable Slicers: Find Items in Large ListsYes. In Excel for Microsoft 365 on Windows, a slicer can have a search box that helps you find items in its…
- Excel Scatter Plot With Two Y-Axes: How to Make OneYes. In Excel for Microsoft 365 on Windows, create an XY scatter chart, select the data series that needs its own scale,…
- Excel Scatter Plot Vertical Line: Add One and Format ItTo add a vertical line to an Excel scatter plot, create a helper series with the same X value in two rows…
- Excel Scatter Plot With Filters: How to Set It UpYes. In Excel for Microsoft 365 on Windows, create a scatter chart from an Excel Table, then filter the table with its…
- Excel Scatter Plot: How to Swap X and Y AxesTo swap the X and Y data in an Excel scatter plot, select the chart, choose Chart Design > Select Data, select…
- Excel Scatter Plot Regression Line: Add and Interpret ItTo add a regression line in Excel for Microsoft 365 on Windows, select your scatter plot, then choose Chart Design > Add…
- Excel Scatter Plot Not Showing All Data? Try These FixesIf an Excel scatter plot is missing points, check the chart’s X and Y ranges first, then look for hidden or filtered…
- Excel Scatter Plot: How to Ignore Zero ValuesYes. To make an Excel scatter plot ignore zero values, replace the zeros you mean to exclude with #N/A in helper columns,…
- Excel Scatter Plot Line of Best Fit: Add and InterpretTo add a line of best fit in Excel for Microsoft 365 on Windows, select your scatter plot, then choose Chart Design…
- Excel Scatter Plot: How Blank Cells Are HandledYes. In Excel for Microsoft 365 on Windows, an XY scatter plot normally treats truly empty cells as gaps, so a row…
- Excel Scatter Plot From a Table: Steps and TipsTo make an Excel scatter plot from a table, select the two columns containing your numeric X and Y values, then choose…
- Excel Scatter Plot: How to Change X and Y Axes CorrectlyTo change the X and Y data in an Excel scatter plot, select the chart, choose Chart Design > Select Data, select…
- Excel Return Table Data as JSON: Methods and LimitsExcel does not have a built-in worksheet function that returns any table as a ready-to-download JSON file. For a reusable export in…
- Excel Repeatedly Not Responding? Causes and FixesIf Excel repeatedly shows “Not Responding,” first give it a short time to finish, especially if a large workbook is calculating or…
- Excel Remove Duplicates While Keeping the Oldest DateTo remove duplicate records in Excel while keeping the oldest date for each item, sort the entire table by the item’s identifying…
- Excel Remove Slicer: How to Delete or Clear OneTo remove a slicer in Excel for Microsoft 365 on Windows, click its outer border so the slicer object is selected, then…
- Excel Remove Everything but Duplicates: Keep RepeatsYes. To remove everything but duplicates in Excel, count how often each value or row occurs, keep records with a count greater…
- Excel Remove Duplicates Not Available? Fixes to TryYes—Remove Duplicates is available in current Microsoft Excel for Microsoft 365 on Windows. Select a cell in your data, then choose Data…
- Excel Remove Duplicates: Why No Duplicates Are Found and What to CheckIf Excel’s Remove Duplicates command reports that no duplicates were found, it means no two rows matched across the columns you selected—not…
- Excel Remove Duplicates: Which Rows Stay and Which Go?Excel’s Remove Duplicates command keeps the first matching record in the current order and removes later records that match it in the…
- Excel Remove Duplicates by Multiple CriteriaTo remove duplicate records in Excel based on more than one field, select your data, choose Data > Remove Duplicates, and check…
- Excel Remove Duplicates: How It Works and When to Use ItExcel’s Remove Duplicates command deletes repeated records from a selected range or table: select the data, choose Data > Remove Duplicates, select…
- Excel Remove Duplicates Greyed Out? Fixes That WorkIf Excel’s Remove Duplicates command is greyed out, first exit cell-editing mode, click a normal worksheet cell, and check whether multiple sheet…