Delete rows in Excel?

slipd · 15 Aug 2019 at 15:04

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

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

Thanks.

chroniclard · 15 Aug 2019 at 15:05

Right click delete....? (Have to highlight the actual full row using the numbers on the side)

Bounce · 15 Aug 2019 at 15:07

chroniclard said:
Right click delete....? (Have to highlight the actual full row using the numbers on the side)

this +1

slipd · 15 Aug 2019 at 15:12

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.

slipd · 15 Aug 2019 at 15:15

Cracked it! Unprotect sheet and then drag the grey line up...

Thanks people.

Bounce · 15 Aug 2019 at 15:17

slipd said:
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.