Delete rows in Excel?

Soldato
Joined
26 Feb 2004
Posts
4,788
Location
Hampshire, England.
Hi guys,

I've inherited a spreadsheet at work and I'm now working on the aesthetics - how do I delete the rows I've highlighted? I'm struggling :(

grey.jpg


I want the rows to stop after 52 and I guess they need to be 'greyed' like the subsequent rows?

Thanks.
 
Ha, it's not having any off it! It's a very secure sheet, so there are lots of things locked down etc. Notice how the row number just stops a 54?!

The sheet after that is all grey. I want the two unwanted rows like that.
 
Ha, it's not having any off it! It's a very secure sheet, so there are lots of things locked down etc. Notice how the row number just stops a 54?!

The sheet after that is all grey. I want the two unwanted rows like that.

if its protected you will need to go Review > Unprotect Worksheet > enter password.
 
Back
Top Bottom