Forum Discussion
Excel filter issues
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.
Thank you Sergei. Sadly your answer is discouraging. Is there any other way to protect the formulas? I thought about Array but there is another problem I am going to post next. Any other way?
For my knowledge - nope, you can't sort/filter the range with mix of locked and unlocked cells.
