There are times when it is necessary to edit the **Data Table**. Sometimes we need to** delete the Data Table** or edit the information in the table. **Excel** can be an extremely useful tool for editing **Data Tables**. Let’s take a look at **how to edit a data table in Excel** now.

**Table of Contents**hide

## Download Practice Workbook

To practice by yourself, download the following workbook.

## What Is Data Table in Excel?

**Excel Data Table** is a set of cells that are linked to the **What-If Analysis tool**. You can experiment with various input values and interpret the results appropriately. Single-variable and two-variable data tables are the two types of available data tables. In a **1 variable Data Table**, you can work with a single variable, and in a **2 variable Data Table**, you can work with two variables simultaneously.

## Step-by-Step Procedures to Edit a Data Table in Excel

To explain the steps, we will use a dataset that contains information about a** Company’s Capital**, **Growth Per Year **and** Total Revenue**. By using the** Excel Data Table**, we have figured out how **Total Revenue** changes with the change in **Growth Per Year**. In **STEP 1**, you will see the **Data Table**. Let’s follow the steps below to understand how it works.

### STEP 1: Make Data Table Ready

- First of all, we need to make
**Data Table.** - To do so,
**insert**the data in an**Excel**sheet and then form a**Data Table.** - We have used the
**range B4:C6**to insert the company’s information. - Then we made the
**Data****Table**by varying the**Growth Per Year information.** - Now we will edit this
**Data****Table.**

**Read More:** **How to Make a Data Table in Excel (Easiest 5 Methods)**

### STEP 2: Select Data Table Range

- In the second step, select the
**Data Table Range**from where you want to edit data. - As we want to edit the information regarding the
**Growth Rate**from**11**% to**15**%, we will select the**Range F4:G10.**

** **

**Read More:**** How to Change Chart Data Range in Excel (5 Quick Methods)**

### STEP 3: Remove Data Table Formula

- In the
**Formula Bar**, we can notice the**Data****Table**formula. - Thirdly, we need to
**Delete**this**Data****Table**formula from**Formula****Bar**.

- Select the formula and press the
**Delete**button to erase the Data Table Formula.

**Similar Readings**

**Data Table Not Working in Excel (7 Issues & Solutions)****How to Add Data Table in an Excel Chart (4 Quick Methods)****How to Format Data Table in Excel Chart (4 Easy Methods)**

### STEP 4: Insert Specific Value

- Then, we will
**insert**the value of our own choice. - Suppose we want to show the value
**70000**and so we will insert**70000**. - Now, press
**CTRL**+**ENTER**.

### STEP 5: Edit Data Table

- After that, the inserted value will be in all selected cells.
- Now, you can edit each individual cell of the
**Data Table**according to your preferences.

## How to Delete Data Table in Excel

Naturally, we can not **delete** any cell from the data table in **Excel**. So, we will give you an **example** of **How to Delete a Data Table.** To complete the task we have used the same data set used before.

Let’s follow the steps below to learn how we can delete a Data Table in Excel.

**STEPS:**

- Firstly, take a look If you can
**delete**any cell from the data table. - But it is showing a
**warning message**which is**Can’t change part of a data table**.

- To delete the
**Data Table**, select the entire range of the data table. - So, we have selected the
**r****ange F4:G10.**

** **

- Now, press
**Delete**on the keyboard**.** - Now the entire
**Data Table**is deleted**.**

** **

- Instead of pressing
**Delete**from the keyboard, after selecting the range, we can**right-click**on the mouse. - Then, A
**Menu Box**window will open up. - From the
**Menu Box**, select**Delete**.

- After that, another dialog box will pop up.
- We will select
**Shift cells left**and press**OK**.

- Finally, the
**Data Table**is deleted.

** **

## Conclusion

In this article, we have demonstrated the way** to edit a data table in Excel**. Furthermore, there is a practice workbook at the beginning of the article. So, go ahead and give it a try. To read similar articles, check out the **ExcelDemy **website. Last but not least, please use the **comment section** below to post any questions or make any suggestions you might have.