How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel ZIP Code Heat Maps: How to Build and Read ThemYes. In Excel for Microsoft 365 on Windows, select a table of ZIP codes and values, then choose Insert > Maps >…
- Heat Map in Excel: How to Create OneTo create a heat map in Excel for Microsoft 365 on Windows, select the numeric cells you want to compare, then choose…
- Group Rows in Excel by Cell ValueTo group rows in Excel by a cell value, first sort the list by the column containing that value, then select the…
- Group Rows in Excel: How to Collapse and Organize DataTo group rows in Excel for Microsoft 365 on Windows, select the row numbers you want to group, then choose Data >…
- Group Rows and Columns in Excel: Steps, Outlines, and FixesTo group rows or columns in Excel for Microsoft 365 on Windows, select the adjacent row numbers or column letters, then choose…
- Group Rows in Excel by Column Value: 3 MethodsTo group rows in Excel by a column value, sort the records by that column and use Data > Outline > Subtotal…
- Goal Seek in Excel: Find the Input for a TargetGoal Seek in Excel finds the value a single input cell must have to make a formula cell reach a target. In…
- Gold Data in Excel: Build a PivotTableYes. To analyze gold data in an Excel PivotTable, put each observation in a separate row, keep dates and numeric values in…
- Goal Seek in Excel: Definition, Steps, and ExamplesGoal Seek in Excel is a What-If Analysis tool that finds the input value needed to make a formula return a result…
- Goal Seek in Excel: How to Find a Target ValueIn Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Goal Seek. Choose a formula cell under Set cell,…
- Goal Seek in Excel: Where to Find It and How It WorksIn Excel for Microsoft 365 on Windows, find Goal Seek on the Data tab: choose What-If Analysis in the Forecast group, then…
- Goal Seek in Excel: A Practical Step-by-Step ExampleTo practice Goal Seek in Excel, create a formula that depends on one input, then choose Data > What-If Analysis > Goal…
- Goal Seek in Excel Online: What Works in the CloudExcel for the web does not currently include the Goal Seek command, so you cannot run Goal Seek directly in a browser.…
- Goal Seek in Excel Browser: Limits and WorkaroundsNo: Excel for the web does not currently include the built-in Goal Seek command. To use Goal Seek on a workbook you…
- Goal Seek in Excel: How to Find the Input You NeedGoal Seek in Excel finds the input value that makes a formula return a result you specify. In Microsoft Excel for Microsoft…
- 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 >…
- Goal Seek Button in Excel: Where It Is and How to Use ItIn Excel for Microsoft 365 on Windows, find Goal Seek at Data > What-If Analysis > Goal Seek. To use it, choose…
- 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 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 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 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…