Forum Discussion
Turn Off Calculated Columns
Hello Everyone,
I have a workbook with multiple sheets with a different table on each one. A lot of the columns needs consistent formulas and so calculated columns are great for this. However, ...
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.
