I'm a user with editing rights. How can I view a sheet as a non-editing user would see it?

Options

I'm an editing user.

I can lock rows and columns.

I can unlock rows and columns.

Annoyingly, I can still delete cell contents when the row or column is locked. That's not how I want it to work - I'd prefer to have to unlock those rows or columns and then do it. I have no way of getting a feel for how a non-editing user can use (or abuse) the sheet.

Is there some mode or option I can use to change this please?

Best Answer

Answers