How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Goal Seek in Excel: Basics, Steps, and Practical ExamplesIn Excel for Microsoft 365 on Windows, Goal Seek works backward from a desired formula result: choose Data > What-If Analysis >…
- Generate a Heat Map in Excel: Color Scales and TipsTo generate a heat map in Microsoft Excel for Microsoft 365 on Windows, select the numeric cells, then choose Home > Conditional…
- Four-Quadrant Scatter Plot in Excel: How to Make OneTo make a four-quadrant scatter plot in Excel, create an XY scatter chart, then add one vertical and one horizontal line at…
- Flash Fill in Excel: How to Fill Data by Pattern CorrectlyFlash Fill in Excel detects a pattern in examples you type and fills matching values into nearby cells; on Windows, select the…
- 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 Settings in Excel: How to Enable or DisableIn Excel for Microsoft 365 on Windows, go to File > Options > Advanced and check or clear Automatically Flash Fill to…
- 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…