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 s...