How to Edit a Data Table in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.

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.

how to edit a data table in excel

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.

Select Data Table Range

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.

Remove Data Table Formula

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

Similar Readings

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.

Insert Specific Value

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.

Edit Data Table

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.

How to Delete a Data Table in Excel

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


  • 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 range 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.


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.

Related Articles

Sudipta Chandra Sarker
Sudipta Chandra Sarker

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel. Here I will be posting articles related to this. My educational degree is BSc in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology, Bangladesh. I have a great interest in research and development. I always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF