Sorting a protected set of cells


O

ordnance1

I want to sort a range of protected (locked) cells. When I set the
protection for the cells I clicked on the Sort option, but my cells still
will not sort. What is the point to the Sort option in the Protect Sheet
dialogbox?
 
Ad

Advertisements

O

ordnance1

I know. And that is what I did, but my question is what is the purpose of
the Sort option on the Protect Sheet dialogbox?
 
Ad

Advertisements

G

Gord Dibben

The purpose is...........It allows you to sort a range of contiguous
unlocked cells on a sheet.

Unlock A1:F30

Protect sheet with allow sort enabled.

Select A1:F30 or any range with A1:F30 and you can sort that range

Select A1:G30 or A1:D31 and be denied.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top