Forum Discussion
Turn Off Calculated Columns
Benjamin Wooler wrote:
A lot of the columns needs consistent formulas and so calculated columns are great for this. However, some of the columns I don't want to have this enabled.
5th Excel commandment: Thou shalt never have different formulas in a column.
I know unless it's a hyperlink formula. Because I'm not going to have every cell take you to the same place and have the same friendly name.
Just add two additional columns - one with the link and one with friendly name - and refer to these cells in the hyperlink formula.
I can do that. But shouldn't there be a way to not have it copy cells down? Because not all of my columns copy the formulas down. And some have the same formula in all of it's cells.
Why not? It doesn't hurt. And there are over 16000 columns available.
You could enter any text or number in all of the column cells and then replace it one by one with the formulas. But that would violate the 5th Excel commandment. And you can't be sure that Excel doesn't pick up one of the formulas when entering new rows.