Forum Discussion
Turn Off Calculated Columns
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.
If I understand your suggestion correctly, that doesn't work. Currently, it doesn't matter what I have in those columns (even nothing), it still copies the formula down when I create a new row. At this point, I can't even change that formula because the formula that it's copying down doesn't exist in the column anymore.