If I lock cells
A1:A3000, is there a way to insert rows in columns
I highlight them and I don't get the option to insert even though it is selected in the lock options. (Bottom line is that I need column A static, not to move.)
Any ideas? Is it even possible?
Better yet, is there any way to have formulas in column A static, as I insert rows in column B? Column A formulas change cell location when I do so.