200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hello,
I have looked through various Excel user forums and cannot find a suitable answer to the following. I need to be able to enable users to sort data on an Excel table where the sheet is protected. On the Protect Sheet menu I checked "allow users to sort". However, when the sheet is protected, the table cannot be sorted.
Thank you.
Hello Susan,
I don't know of a way to allow data on a protected sheet to be sorted but it is possible to allow filtering. To allow filtering do the following before protecting the sheet. Select the table of data including headings and then on the Data tab click on "Filter". The sheet can now be protected. Cells in the table can be locked to prevent corruption of the data. Your users can now filter the data (using the down arrows in the header row) to only include the data they are interested in.
Update 10:53pm
Just found this link which describes how to allow sorting and filtering of a protected sheet.
If this solves things for you please remember to mark my answer as Selected.
Cheers :-)
