Forum Discussion
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.
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.