Can I insert rows next to a locked column in Excel?
- by Tom
If I lock cells A1:A3000, is there a way to insert rows in columns B-Z?
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…