Forum Discussion

erlacour's avatar
erlacour
Copper Contributor
Apr 03, 2023
Solved

EXCEL - Protection of cells

I want to protect my cells but also to be able to hide some row if they are empty. I'm able to protect my cells, but I don't know if is it possible (and how) to hide some rows if those cells are pro...
  • HansVogelaar's avatar
    Apr 03, 2023

    erlacour 

    When you protect the sheet, tick the check box 'Format Columns'. You will then be able to hide and unhide rows on the protected sheet.

Resources