Excel: locking cells and filtering
Solved
CNAT
Posted messages
21
Registration date
Status
Membre
Last intervention
-
ordo -
ordo -
Hello,
In an Excel spreadsheet with cells containing formulas that I have locked, I would also like to access the AutoFilter during data entry, but I need to unprotect my sheet to access the AutoFilter.
Is it not compatible to have certain cells locked in Excel and enable the AutoFilter? Do we have to remove the sheet protection to access the AutoFilter, or is there a trick to have access to this filter while also keeping certain cells locked?
Thank you in advance for the answers.
Nat
In an Excel spreadsheet with cells containing formulas that I have locked, I would also like to access the AutoFilter during data entry, but I need to unprotect my sheet to access the AutoFilter.
Is it not compatible to have certain cells locked in Excel and enable the AutoFilter? Do we have to remove the sheet protection to access the AutoFilter, or is there a trick to have access to this filter while also keeping certain cells locked?
Thank you in advance for the answers.
Nat
Configuration: Windows XP Internet Explorer 6.0
5 réponses
Hello,
I'm making my small contribution after searching quite a bit on this subject
My solution for Excel 2010 is as follows:
1) In the "Home" tab => "Styles" => format as a table
2) Select the table, check the box that says my table has headers
3) "Review" tab => "Changes" section => click on "Allow users to edit ranges"
4) In the dialog box => New => select the whole table => click on Apply => protect the sheet
5) Check select unlocked cells, check sort, check use auto filter, uncheck all others
6) Click OK
7) RESULT: your sheet is protected and you have the ability to filter
I don't have a better solution, feel free to share if you have another one, I'm all ears ;)
I'm making my small contribution after searching quite a bit on this subject
My solution for Excel 2010 is as follows:
1) In the "Home" tab => "Styles" => format as a table
2) Select the table, check the box that says my table has headers
3) "Review" tab => "Changes" section => click on "Allow users to edit ranges"
4) In the dialog box => New => select the whole table => click on Apply => protect the sheet
5) Check select unlocked cells, check sort, check use auto filter, uncheck all others
6) Click OK
7) RESULT: your sheet is protected and you have the ability to filter
I don't have a better solution, feel free to share if you have another one, I'm all ears ;)
It doesn't work completely!!!
With Excel 2010, I selected my table as instructed, the auto filter works correctly (I checked auto filter and sort). But every time I try to sort from A to Z or Z to A, it asks me to remove the sheet protection in order to sort... :(
Do you have the solution to completely resolve the issue??