On a protected sheet every command follows the same rules as Excel 365, and the buttons, the menus, the shortcuts and the windows always give the same answer. A command the protection doesn't allow is grey, and clicking it tells you why; a gesture without a button, such as typing into a locked cell, shows Excel's message.
Content. Typing, clearing, pasting, filling, replacing, moving cells, array formulas and the tools that write into the sheet — Goal Seek, Solver, Consolidate, Data Analysis — are refused if even one target cell is locked and outside the editable ranges, and then no cell changes. On unlocked cells, without Format cells only the contents are pasted, and Clear All keeps the formatting.
Always off, whatever you tick: changing a cell's Locked or Hidden formula setting, merging and unmerging cells, data validation, grouping and ungrouping rows or columns, inserting or deleting cells by shifting the others, every table feature, turning the filter on or off, the sheet background, inserting sparklines, the editable ranges, Remove Duplicates, Subtotal, Data Table, Text to Columns and Flash Fill.
With their option. Format cells allows formats, styles, conditional formatting and existing sparklines, on locked cells too. Format columns and Format rows allow width and height, hiding and unhiding, and expanding and collapsing groups. Insert columns and Insert rows are enough on their own. Use AutoFilter allows choosing the criteria, and clearing and reapplying a filter that is already on.
With the option and unlocked cells. Delete rows and Delete columns work on whole rows or columns selected, and need every deleted cell to be unlocked; Sort needs the whole range unlocked, header included; Insert hyperlinks needs the cell unlocked, and a link can only be removed from an unlocked cell.
PivotTables, objects and scenarios. With Use PivotTable & PivotChart you can create PivotTables and change their fields and layout, but refreshing them, filtering their items and changing their source stay off, and Refresh All skips those on protected sheets. Without Edit objects no objects can be inserted, a locked object can't be selected — the click goes to the cell underneath — and notes can't be edited; comments can always be written. Without Edit scenarios, locked scenarios can't be changed or deleted and hidden ones don't appear, but adding one is still possible.
Hidden formulas. A cell with Hidden formula shows only its result: the formula doesn't appear in the formula bar, in the cell being edited, with Show Formulas, in the Watch Window or in Evaluate Formula, and FORMULATEXT returns #N/A.