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?
 
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?
 
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

Similar Threads

Allowing sort of protected cells 1
Sorting a protected sheet 1
range definition by cells numbers 3
Sorting Protected Worksheet 4
Enabling Autofilter and Sorting in a Protected Sheet 2
Is autofilter & sort disabled in protected cells? 1
Sorting while protected - this question may not have been covered. 1
sorting grouped cells 1

Top