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

STEP 1 – Make Data Table Ready

  • Create a data table.
  • Insert the data into the data table.
  • We have used the range B4:C6 to insert the company’s information.
  • Create a data table by varying the Growth Per Year information.

how to edit a data table in excel

STEP 2 – Select Data Table Range

  • Select the data table range you want to edit.
  • 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

STEP 3 – Remove Data Table Formula

  • Delete the data table formula from Formula Bar.

Remove Data Table Formula

STEP 4 – Insert Specific Value

  • Enter the desired value.
  • We want to show the value 70000, so we will insert 70000.
  • Press CTRL + ENTER.

Insert Specific Value

STEP 5 – Edit Data Table

  • The entered value will be in all the selected cells.
  • You can customize each cell in the data table to suit your needs.

Edit Data Table

How to Delete Data Table in Excel

When you try to delete any cell from the data table, it will show a warning message, “Can’t change part of a data table”.


  • To delete the data table, select the entire table range.
  • We have selected the range F4:G10.

  • Press Delete on the keyboard to delete the entire data table.

  • Or Right-Click on the selected data table.
  • In the Context Menu, select Delete.

  • In the dialog box, select Shift cells left and click OK.

  • The data table will be deleted.

Download Practice Workbook

Related Articles

<< Go Back to Data Table in Excel | What-If Analysis in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sudipta Chandra Sarker
Sudipta Chandra Sarker

Sudipta Chandra Sarker, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked on the ExcelDemy project for over a year. For ExcelDemy, he has authored 42 articles and reviewed over ten articles. He is employed as a junior software developer at the moment. He aims to create various useful Microsoft Office Add-ins, extending the functionality of Office programs. His interests span Microsoft Office Suites, Data Science, VBA, VB.NET, ASP.NET, C#, Excel, and Desktop... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF