Excel 2010 Table Auto Format

By ps2057 ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums