Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Allow Sorting and Filtering of Locked Cells in Protected Sheets in Excel?
When we want to perform sorting and filtering in the locked cells in protected sheets, it will not be possible because the protected sheets, which are created with default settings, can’t be able to do so. But if we follow the below-mentioned process, we will be able to allow sorting and filtering even for locked cells in protected sheets. In this tutorial, we will learn about how we can allow sorting and filtering of locked cells in protected sheets.
Allowing Sorting and Filtering of Locked Cells in Protected Sheets
Here we will first create a table, then protect the sheet while allowing sorting and filtering for the sheet. Let us look at a simple procedure for sorting and filtering locked cells in protected sheets.
Step 1
Let us consider an Excel sheet that contains a table, as shown below.
To begin, we must create a table for the data; to do so, select it, click Insert, select the table menu, and then OK in the pop-up to successfully generate a table.
Step 2
Now click on the review and select protect and allow edit ranges as shown in the below image.
After that, a new pop will be opened.
In the new popup, enter the title as "Allow Sort" and click on "OK" to close the popup, and the older popup will be opened.
Step 3
In the new pop-up window, click on the protect sheet, and then again, a new pop-up window will be opened.
Enter the password that you want to use to protect the sheet in the password box.
Check the boxes next to "Sort" and "Use auto filter," then click OK to close the pop up window.
After clicking on "OK," the system again asks for confirmation of the password to proceed. Enter the password that you created and click "OK" to finally complete our process.
Conclusion
In this tutorial, we used a simple example to demonstrate how we can allow sorting and filtering locked cells in protected sheets in Excel to highlight a particular set of data.
10K+ Views
