EXCEL Prevent range from being deleted

Question

I want to be able to delete or add rows in Section A without moving Section B without protecting the sheet.

Is there a way to sort of 'freeze' all those columns so they won't move? so if the user just wants more columns they can just right click on a entire row to add, or delete

Help is appreciated!

Answer 1

Delete

Select exactly what you want to delete. Press Ctrl + - (Control and Minus Sign) or choose Delete... in a context menu. Choose Shift cells up in a pop-up menu.

Insert

Select the range to insert. Press Ctrl + + (Control and Plus Sign) or choose Insert... in a context menu. Choose Shift cells Down in a pop-up menu.

---

Answer to additional question

Is there a way to sort of freeze all those columns so they won't move when the user wants more rows to add?

In general - no. But if you manage to convert the left side (A in your picture) into an Excel Table aka Excel List then you can operate with rows and columns inside of it.