Hi,
I've turned on the "protect sheet" feature in order to be able to lock
certain cells and hide the formulas in these locked cells. When i turned this
feature on, i clicked that i wanted to allow all users of this worksheet to
sort. However, when i highlight the rows i want and try to sort them, it
won't let me. A window pops up saying "the cell or chart you are trying to
change is protected and therefore read-only.". How do i lock certain cells so
that people cannot type over the formula, but still be able to sort the
spreadsheet?