Skip to content
- Excel Sort Expand Selection Not Working? Try These FixesIf Excel’s Expand the selection option is not working, cancel the sort, select the entire data range—including every column that belongs to…Errors & fixes
- Excel Sort Dates From Earliest to Latest: A Clear GuideTo sort dates in Excel from earliest to latest, select a cell in your date column, then choose Data > Sort &…Formulas & functions
- Filter an Excel Table by Value: Steps, Tips, and FixesTo filter an Excel table by value in Microsoft Excel for Microsoft 365 on Windows, click the arrow in the relevant column…Formulas & functions
- Filter Excel Table by Text: Steps, Options, and FixesTo filter an Excel table by text in Microsoft 365 for Windows, select the drop-down arrow in the column heading, point to…Formulas & functions
- Filter Excel Table by Color: Steps and TroubleshootingYes. In Excel for Microsoft 365 on Windows, open the filter arrow in the table column containing the colored cells, choose Filter…Formulas & functions
- Excel Filter Shortcut: How to Turn Filters On and OffIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off. Select a cell in your data first;…Formulas & functions
- Excel FILTER: What the Include Argument DoesIn Excel’s FILTER function, include is the test that decides which rows or columns to return: TRUE keeps an item, and FALSE…Formulas & functions
- Filter Excel Rows in Power Automate: Methods and TipsTo filter Excel rows in Power Automate, use List rows present in a table and enter a condition in its Filter Query…Formulas & functions
- Filter Excel for Empty Cells: Blanks and FormulasTo filter for empty cells in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter,…Formulas & functions
- Filter Excel Horizontally: Methods That WorkYes, you can filter Excel horizontally, but the standard Filter dropdown is designed to filter records in rows, not to hide or…Formulas & functions
- Filter an Excel Column Based on a List of ValuesTo filter a column in Excel for Microsoft 365 on Windows, select your data, choose Data > Filter, open the target column’s…Formulas & functions
- Filter Excel by Highlighted CellsYes. In Excel for Microsoft 365 on Windows, open the filter arrow in the column containing the highlighted cells, choose Filter by…Formulas & functions
- Filter Excel by Date: Steps, Custom Ranges, and FixesTo filter dates in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the…Formulas & functions
- Excel How to Filter Columns: Steps and TipsTo filter columns in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, then use…Formulas & functions
- Excel Filter Shortcut Keys: Apply, Open, Clear, and UseIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for a data range, and press Alt+Down…Formulas & functions
- Excel Filter Not Showing All Items? Find the CauseIf an Excel filter is not showing all items, first clear filters on every column, then check that the filter covers the…Formulas & functions
- Excel Filter Not Showing All Data? Find the Cause FastExcel filters usually miss rows because the filter range stops before the full dataset, or because the values that look alike are…Formulas & functions
- Excel Filter Not Applying to All Rows? How to Fix ItIf an Excel filter is not applying to all rows, its selected range probably stops before the remaining data—often at a blank…Errors & fixes
- Excel INDIRECT Drop-Down Lists: Setup and FixesTo make a dependent drop-down list in Excel, create a named range for each set of choices, then set the second list’s…Formulas & functions
- INDIRECT Excel Not Working? Fix the ReferenceIf INDIRECT is not working, check that its text builds a valid cell reference, that the referenced sheet or workbook is available,…Errors & fixes
- INDIRECT in Excel: How to Drag Formulas to New CellsIf you want an INDIRECT formula to follow different cells as you drag it, build its address from a relative cell reference…Formulas & functions
- Excel INDIRECT Errors: Causes, Fixes, and ExamplesAn Excel INDIRECT error usually means the text supplied to INDIRECT cannot be turned into a valid cell or range reference; the…Formulas & functions
- INDIRECT in Excel: Create Dynamic Cell ReferencesIn Excel, INDIRECT turns text that looks like a cell or range address into a usable reference. For example, if D1 contains…Formulas & functions
- Excel Copy and Paste Slow? Practical Causes and FixesWhen Excel is very slow copying and pasting, the usual causes are a large or complex selection, heavy formatting, formulas that recalculate,…How-to basics
- Excel Very Slow Saving Files? Causes and FixesIf Excel is very slow saving files, first save a copy to a local folder and compare the time with the original…How-to basics
- Excel Bar Plot: How to Create and Format OneIn Excel for Microsoft 365 on Windows, select your category and value columns, then choose Insert > Insert Column or Bar Chart…How-to basics
- Excel Formula Bar: What It Shows and How to Use ItIn Excel, the Formula Bar is the field above the worksheet that shows the contents of the selected cell and lets you…Formulas & functions
- Excel Bar Over Bar Graph: How to Overlay Two Data SeriesTo put one data series over another in an Excel bar chart, select a bar, open Format Data Series, and set Series…Charts & pivot tables
- Excel Bar Names: What Each Part of the Window DoesIn Excel for Microsoft 365 on Windows, the main interface areas people call “bars” include the title bar, Quick Access Toolbar, ribbon,…How-to basics
- Excel Bar Graph Too Skinny? Fix Bar Width and SpacingIf an Excel bar graph looks too skinny, select a bar, open Format Data Series, and reduce Gap Width under Series Options.…Charts & pivot tables