Forum Discussion
Hide cells in locked excel spreadsheet
Hi!
I work with a locked excel spreadsheet at work to do scheduling, but there are too many blank rows! I want to be able to hide/delete rows, but because it is locked, it won't let me do it the simple way!
Does anyone have a different way that could possibly work in a situation like this?
Thank you!
When you protect the worksheet. Just check the box that says Format Rows. This will allow you to hide and unhide rows.
