How to Sort within AutoFilter with Protection on (and AutoFilter .


G

Guest

Sort Ascending / Descending don't seem to work when Protection is turned on,
even if the AutoFilter and Sort check box is checked when enabling Protection.

1. Tools -> Protection -> Protect Sheet -> check Use AutoFilter (and Sort if
you wish).
2. Data -> Filter -> AutoFilter.
3. Click any column heading -> Sort Ascending or Descending - no change in
data.
 
Ad

Advertisements

J

Jim Rech

The cells to be sorted must be unlocked even with this protection option.

--
Jim
| Sort Ascending / Descending don't seem to work when Protection is turned
on,
| even if the AutoFilter and Sort check box is checked when enabling
Protection.
|
| 1. Tools -> Protection -> Protect Sheet -> check Use AutoFilter (and Sort
if
| you wish).
| 2. Data -> Filter -> AutoFilter.
| 3. Click any column heading -> Sort Ascending or Descending - no change in
| data.
 

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

Enabling Autofilter and Sorting in a Protected Sheet 2
autofilter sort not visible 1
Sorting while protected - this question may not have been covered. 1
Sorting with AutoFilter 1
MS Excel 2003 - Autofilter for protected cells 1
AutoFilter issues 4
Autofilter not working on protected sheet. 1
Autofilters not working when sheet is protected 10

Top