- Nov 20, 2007
I unlocked the top row, which is filtered, then protected the worksheet, as there are a couple of columns with formulas that I do not want touched. However we should be able to filter the sheet. I cannot figure out how to protect the sheet and still be able to filter the data. How can I do this?