I have a large Excel table where rows of data are entered daily. I have auto format turned on so that formulas and formats automatically copy to new rows – love this!
The problem: I need to eliminate the formula in one column going forward. The formulated data in the existing rows needs to stay, so can’t delete the column. I have tried deleting the formula, but on the next row entered it reappears.
I have 20 columns with formulas so do not want to turn off auto formatting.
Is this possible?
