Home // Blog & Excel Tips // Excel data table formula replaced with values

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Excel data table formula replaced with values

Comments Closed
Uncategorised

Data tables are an extremely useful feature in Excel and help you run complex sensitivities. However if you try and move them around you may discover that they seem to stop working. In fact if you look closely enough you will see Excel data table formula replaced with values.

This is normal in Excel. If you copy and paste or cut and paste a data table, depending on how it is done, it acts as a copy paste as values and the formula and hence the power of the data tables are lost.

In order to activate them again, you need to re do the process i.e highlight the cells (1 below) and switch the data tables back on (2)

single-variable-data-table-in-excel
Data tables in Excel