About 1,950,000 results
Open links in new tab
  1. Table of Contents
    Excel Data Tables
    Jump to section

    Excel Data Tables

    This summary was generated by AI from multiple online sources. Find the source links used for this summary under "Based on sources".
    Learn more about Bing search results here
    Guide on Excel What-If Analysis
    Organizing and summarizing search results for you

    A data table in Excel is a tool used for What-If Analysis. It allows users to change the input values of a formula and observe how those changes affect the output. There are two types of data tables:

    • One-variable data table: Tests different values for a single input.
    • Two-variable data table: Examines the effects of two different inputs on the output.

    Data tables are particularly useful for scenarios where the output depends on multiple variables, enabling users to compare results efficiently. spreadsheeto.com 1 3

    On this page:
    Based on 2 sources:
    Spreadsheeto
    https://spreadsheeto.com/data-table-excel/
    1
    How to Make a Data Table in Excel: Step-by-Step Guide (2024) - Spreadsheeto
    Data tables in Excel are used to perform What-if Analysis on a given data set. Using data tables, you can analyze the changes to the output value by changing the input values to a …
    Microsoft
    https://support.microsoft.com/en-us/office/calculate-multiple-results-by-using-a-data-table-e95e2487-6ca6-4413-ad12-77542a5ea50b
    3
    Calculate multiple results by using a data table
    In Excel, a data table is a range of cells that shows how changing one or two variables in your formulas affects the results of those formulas.
    spreadsheeto.com
    microsoft.com
    Feedback
  2. Microsoft Logo
    Help from Microsoft
    https://support.microsoft.com/article/bf0ce08b-d012-42ec-8ecf-a2259c9faf3f

    Create a table in Excel

    You can create and format a table to visually group and analyze data.

    1. Select a cell within your data.

    2. Select Home and choose  Format as Table under Styles.

    3. Choose a style for your table.

    4. In the Create Table dialog box, confirm or set your cell range.

    5. Mark if your table has headers, and select OK.

  3. Feedback
  5. Some results have been removed