Forum Discussion

ALIF_78's avatar
ALIF_78
Copper Contributor
Jun 08, 2025

Data table in Excel copy and paste it within the same sheet

Hi all,

I'm working with a one-variable data table in Excel and would like to copy and paste it within the same sheet while keeping it fully functional — including the array behavior and input cell reference.

Currently, when I copy and paste the data table to a new location:

The pasted result shows only static values (numbers).
The data table array/formula disappears.
I have to go back to Data > What-If Analysis > Data Table and re-enter the input cell reference each time.

Is there a way to duplicate a data table in the same worksheet without needing to manually reset the input cell reference every time?

Any suggestions or workarounds would be appreciated. Thank you!

Resources