Multiple levels of worksheet protection for each cell...
When I protect a worksheet, some cells I don't want the user to be able to select at all, or edit in any way. And some cells I want to lock against the user editing, but still need him/her to be able to select those cells, whether it be for highlighting, copying, etc. Additionally, some cells I want the user to select and enter data, but not be able to edit the formatting of the cell. This is currently easy to attain. However, many of my cells have hidden formulas which I don't want the user to edit but I do want the user to be able to drag those cells down to apply the formula(s) to cells in subsequent rows. But currently, if the formulas in cells are hidden from the user being able to edit them, those formulas also cannot be applied to cells in subsequent rows when the user drags them. Likewise, in some of my financial spreadsheets, I have certain columns of cells with auto-calculations/formulas locked against user edit. When I need to select an entire row to drag and apply the formatting and formulas for each of its cells to the next row, I can't do it because Excel throws an error when attempting to drag a row containing one or more locked cells.
Excel needs 2 or 3 levels of protecting each cell in a worksheet where you can:
a. specify particular cells are locked against any form of user selecting or editing (complete lock down of those cells).
b. specify other particular cells in the same worksheet are locked against user edit, but can still be selected in order to copy their values, and their format/formula can also be dragged and applied to other cells.
c. specify particular cells are unlocked for editing while their formulas ARE locked against editing, but those formulas can still be passed and applied to other cells when dragged.
d. specify particular cells in the same worksheet are unlocked for editing while their formulas are locked against editing and those formulas cannot be passed or applied to other cells when dragged.
Excel has the potential to become one of the greatest, most versatile and useful apps on the planet - if Microsoft would just put in functionality its users actually need instead of continually adding bloat with useless features.