Clearing row with locked cells

[p0ldi]

Hi guys!

Even after intensive searching I could not find a thread concerning this issue, so here it goes:

I have a protected worksheet with various locked columns, looking like this:
A B C D E F G ...
u u l l l u l ...

with u = unlocked and l = locked.

The various protected columns contain formulas, the unlocked cells user data (name, address, etc.). The order of the columns cannot be changed.

If I now want to delete an entire row, meaning deleting a single user, by selecting the row and clicking "clear contents" (or alternatively pressing del on the keyboard), I receive the error message, that the selection contains locked cells.

I would like this action to result in all unlocked cells being cleared and all locked cells being untouched.

How? :D


Thanks in advance.

 

[Richard Schollar]

Hi p0ldi

You can probably do it by selecting your row and going Edit>Goto>Special Button and choosing Constants from the option buttons and clicking OK, then hitting Delete.

Best regards

Richard

 

[p0ldi]

Hi Richard,

Thanks for the reply. Unfortunately the "Special" button is greyed out...