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!
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.
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.
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.
