WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to change data table in Excel

August 1, 2022

A change data table is a great way to store information about changes that have been made to your data. This table can be used to keep track of who made the changes, when they were made, and what affected the data.

Data Management in Excel 2019 Online

If you are looking to make a dramatic change to your data in Excel, there are a few things you need to keep in mind. First, always make a copy of your original data table before making any changes so that you have a safe place to revert to if something goes wrong. Secondly, always use caution when changing any of the data in your table- errors can be costly! Finally, be sure to test your changes before applying them broadly to your entire dataset.

Excel is a popular tool for data management. It can create graphs, charts, and tables to help you understand your data. However, sometimes the information in your data table isn't easy to read. You may want to change the format of your data table so that it's easier to understand.

Way to Change Data Table Excel on Mac Online

There are a few ways to change the format of your data table in Excel.

One Variable Data Table in Excel

To replicate a single variable data table, follow these steps.

1. Select cell B12 and type =D10 (refer to the total profit cell).

2. Type the different percentages in column A.

3. Select the range A12:B17.

4. If you sell 60 for the highest price, 70 for the highest price, and so forth, we'll determine the full profit.

5. On the Data tab, in the Forecast group,

6. Click What-If Analysis.

7. Click Data Table and then Click in the 'Column input cell' box (the percentages are in a column) and select cell C4.

We select cell C4 because the percentages refer to cell C4 (% sold for the highest price). Together with the formula in cell B12, Excel now knows that it should replace cell C4 with 60% to calculate the total profit, replace cell C4 with 70% to calculate the total profit, etc.

8. Result.

In conclusion, changing data in an excel worksheet can be a time-consuming and tedious task. However, with the help of a few simple tools, it can be done quickly and easily,changing a data table in Excel can be a fairly straightforward task, and it can help you to better organize and understand your data. If you need to make changes to more than one row or column, or if you want to add or delete data, it may be helpful to use a data analysis tool like Excel's VBA programming language. However, if all you need is a simple change to a table's content, then changing the table in Excel is an option that's worth considering.

Has this process helped you learn about Change Data Table Excel? If you want to find out more about excel functions and features, you can view and subscribe to WPS Academy to learn.

You should also download and use WPS Office to edit Excel, PowerPoint, PDF, and Word documents for free. Download now and enjoy these free services! With WPS Office, you can create a simple and enjoyable working environment.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.