Hide cells in locked excel spreadsheet

[Emily Gallihugh]

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!

[#2]

When you protect the worksheet.  Just check the box that says Format Rows.  This will allow you to hide and unhide rows.