Forum Discussion
Karen54
Nov 11, 2025Copper Contributor
Same Number
I am trying to log number in a column but after entering the number and going to the next line down the number will switch back to the original number on all the lines.
1 Reply
It maybe the problem when the column is part of an Excel Table or has a formula applied across the column. When you type a number, Excel automatically replicates it to all rows in that structured column. To fix it, convert the table back to a normal range or clear the formula so each cell can hold its own independent value.