Is it possible to keep space if you delete rows in Excel 2016?

Basically, what I want to do is, let's say, delete the rows from 6 to 10, but I want to keep that blank space so rows 5 and 11 don't get together Is it possible to do this? if so, how? Thanks...

excel

Excel Online

Damien_Rosario
Mar 13, 2018
Hi Alan

I'd suggest selecting the rows you want (ensuring it selects all cells in those rows across the spreadsheet) and then clicking onto Merge & Centre in the Home menu tab.

It will retain the rows and give you the buffer you seek.

You can also lock the cells above so it can't be edited by going to the Review menu tab and clicking onto Protect Sheet. The options you want are selected by default. Press OK.

Off the top of my head I'm not sure of a way to do what you are specifically asking, but someone else here might have an idea.

Hope it helps and best wishes to you.

Cheers

Damien

Damien_Rosario

Silver Contributor

Mar 13, 2018

Hi Alan

I'd suggest selecting the rows you want (ensuring it selects all cells in those rows across the spreadsheet) and then clicking onto Merge & Centre in the Home menu tab.

It will retain the rows and give you the buffer you seek.

You can also lock the cells above so it can't be edited by going to the Review menu tab and clicking onto Protect Sheet. The options you want are selected by default. Press OK.

Off the top of my head I'm not sure of a way to do what you are specifically asking, but someone else here might have an idea.

Hope it helps and best wishes to you.

Cheers

Damien