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

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