Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.
To prevent Excel from creating new rows and columns automatically, follow these steps: Here you can find a setting named Include new rows and columns in table. You need to double-click on this setting ...