Forum Discussion
Excel filter issues
Hello,
I have a WS with autofilter in the headder. The WS contains 2 columns of formulas, the rest is supposed to be a Register filled up by unqualified personnel, so I have to protect the sheet for the safety of 2 columns in the middle.
The first columns is a list of family names and needs to be sorted A to Z everytime after new entries.
When I protect the sheet the Filter does not allow to sort from A - Z, it sends a message that I have to unprotect the sheet, even I ticked all options exept delete and insert rows and columns in Protect Sheet table. Other Filter options, like sort by text or color, do work, but sort A to Z doesn't.
What's going wrong? Is there any solution? Thank you.
7 Replies
Hi Natalia,
1) On unprotected sheet unlock the cells you'd like to allow to sort - select them, Ctrl+1 and
2) Select proper options while protecting the sheet
SergeiBaklan wrote:Hi Natalia,
1) On unprotected sheet unlock the cells you'd like to allow to sort - select them, Ctrl+1 and
2) Select proper options while protecting the sheet
Thank you for answering. Unfortunately I started procisely from the actions you suggest. I unlocked the cells on the sheet, exept those with formulas. I ticked all options in the Protect Sheet table. Then I was most surprised with the result and called for help. Does it work on your computer? Is it just a bug on mine? Can I cure it somehow?
Sorry, i was wrong, did'nt read carefully. For my knowledge - nope, you can't sort/filter the range with mix of locked and unlocked cells.
