How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Flash Fill in Excel: Fill to the Last RowTo use Flash Fill through the last row in Excel for Microsoft 365 on Windows, enter one or two examples in the…
- Flash Fill in Excel: How It Works and When to Use ItFlash Fill in Excel recognizes a pattern in your examples and fills the remaining cells with matching results. In Microsoft Excel for…
- Flash Fill Months in Excel: How to Extract Month NamesTo Flash Fill months in Excel, enter the month you want beside the first date, type the next example if needed, then…
- Flash Fill Multiple Cells in Excel: Steps and LimitsYes. In Excel for Microsoft 365 on Windows, Flash Fill can populate many cells in a column by recognizing a pattern in…
- Excel Flash Fill in Polish: Name and How to Use the FeatureIn Polish-language Excel, Flash Fill is called Wypełnianie błyskawiczne. In Microsoft 365 for Windows, find it at Data > Flash Fill in…
- Flash Fill Excel Practice: Examples and TipsTo practice Flash Fill in Excel, put sample data in one column, type the result you want beside the first row, then…
- Flash Fill in Excel: How It Works and When to Use ItFlash Fill in Excel recognizes a pattern in your examples and fills matching values into the rest of a column, such as…
- Flash Fill in Excel: Fill Blanks or Detect PatternsFlash Fill in Excel recognizes a pattern in your examples and fills an adjacent column with matching results; it does not automatically…
- Flash Fill in Excel: Find the Button and Use It CorrectlyIn Excel for Microsoft 365 on Windows, Flash Fill is on the Data tab: choose Data > Flash Fill, or select the…
- Fit Columns to Text in Excel: Quick Methods and FixesTo fit a column to its text in Excel for Microsoft 365 on Windows, select the column and choose Home > Format…
- Fixing a Corrupted Excel File: Recovery StepsTo fix a corrupted Excel file, first make a copy of it, then in Excel for Microsoft 365 on Windows choose File…
- Excel File Extension Corrupted? Causes and Safe FixesAn Excel file-extension error usually means the filename suffix, such as .xlsx, does not match the file’s actual format; it can also…
- Excel File Contains Corrupted Data? Ways to Recover ItIf Excel says a file contains corrupted data, it cannot reliably read some part of the workbook, but that does not automatically…
- Extract Data From a Corrupted Excel File: Safe Methods That WorkTo extract data from a corrupted Excel file, first make a copy of it, then in Excel for Microsoft 365 on Windows…
- Goal Seek in Excel: How It Works and When to Use ItGoal Seek in Excel works backward from a result you want: give it a formula cell, a target value, and one input…
- Expand All Excel Columns to Fit TextTo expand every column in Excel for Microsoft 365 on Windows, click the Select All button at the top-left corner of the…
- Excel X Y Scatter Plot with Multiple Series ExplainedTo make an Excel X Y scatter plot with multiple series, insert a Scatter chart, then use Chart Design > Select Data…
- Excel Won’t Remove Duplicates? Causes and FixesIf Excel won’t remove duplicates, select the complete data range, choose Data > Remove Duplicates, confirm which columns define a duplicate, and…
- Excel Won’t Insert a Row? Causes, Fixes, and WorkaroundsIf Excel won’t insert a row, first select the row header where the new row should go, then choose Home > Insert…
- Excel Print Area Greyed Out: Why It Happens and FixesIn Excel for Microsoft 365 on Windows, the Print Area commands are most often greyed out because multiple worksheet tabs are selected,…
- Excel Protect Sheet Greyed Out? Causes and FixesIn Excel for Microsoft 365 on Windows, Protect Sheet is usually greyed out because Excel cannot currently edit the worksheet or workbook,…
- Excel Insert Row Greyed Out? Causes and FixesIn Excel for Microsoft 365 on Windows, Insert Row is usually greyed out because the worksheet is protected, the file is open…
- Excel Trendlines: Which Type Should You Use for Your Data?Use a linear trendline when your data changes at a roughly steady rate; choose another type only when the data’s shape supports…
- Excel Web Consolidate: What Works and What Doesn’tExcel for the web does not include the desktop Excel Data > Consolidate command. To combine data in a browser, use formulas…
- Excel Web Named Ranges: Create, Edit, and Use ThemIn Excel for the web, a named range is a descriptive name for a cell or range, which you can then use…
- Excel Sheet Protection: How to Protect and Unlock CellsTo protect a worksheet in Excel for Microsoft 365 on Windows, open the sheet, select Review > Protect Sheet, choose what users…
- Excel Remove Duplicates: Safe Steps and AlternativesTo remove duplicates in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Remove Duplicates, select…
- Excel Very Slow or Not Responding? Causes and FixesIf Excel is very slow or shows Not Responding, first give it a short time to finish a calculation or file operation;…
- Excel: View Data as a Table and Use Its FeaturesTo view a range as an Excel table, select a cell in the data and press Ctrl+T in Excel for Microsoft 365…
- Excel Slicers for Multiple PivotTables: How to ConnectYes. In Excel for Microsoft 365 on Windows, one slicer can filter multiple PivotTables when they share a compatible data source or…