Feb 05 2024 10:46 AM
I protected the above worksheet under "protect sheet" option, inserted my password then "ok" but it still allows for deleting of protected cells. The only way around this is if I unselect "select locked cells" and "select unlocked cells". But when I do that I can't search then select any cells.
Feb 05 2024 07:51 PM
Feb 07 2024 09:21 AM
@Rodrigo_I'm not seeing that option. Please see screenshot below. It thinks that the column/chart is protected, but it's not. i can delete those cells. Makes no sense.
Feb 07 2024 02:41 PM
@adlbrk
Follow these steps:
reference>>> Lock or unlock specific areas of a protected worksheet - Microsoft Support
Feb 07 2024 03:32 PM
@Rodrigo_thanks that worked!
But I can't lock certain cells. I highlighted the above columns and protected them but it protects the whole worksheet.