Can anybody tell me how to protect two columns in my Excel Table that contain formulas? I created a table, highlighted the range of cells that I want to unlock, then protect the sheet. I also check that I want to allow users to add rows to my worksheet. As soon as I protect the sheet, the little "carrot" in the bottom right cell of the Table disappears and the ability to insert Table Rows becomes grayed out.
I'm using Excel 2013.
I'm using Excel 2013.
