Kyle Johnson2 said:Since I was already working on this, I figured I’d put in a little extra effort to help you out, assuming this approach works for you.
- How to enable sorting and filtering when cells are locked on a protected worksheet.
It all comes back to that same issue: cell ranges with editing permissions. My specific headache is having several protected columns sitting right in the middle of a table I need to sort. It’s clear Microsoft didn't design the software with this exact scenario in mind. Honestly, it's frustrating. My only real workaround is to unprotect the entire sheet, run the sort, and then lock it back up. That seems to be the only way to handle it. Thanks for the help, regardless.
I just want to ask one more time: why does Ctrl+F fail to search through hidden columns? On certain sheets, it still works perfectly fine, but unfortunately, on most others, it doesn't. I’ve gone looking for a reason, but I can't find any discernible difference between them. It’s inconsistent—sometimes it searches hidden cells, and sometimes it ignores them entirely. Why is this happening?