Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about inserting and deleting rows and columns here.
You can insert a row in a spreadsheet anywhere you need it. Excel moves the existing rows down to make room for the new one.
To quickly insert a row or column, select the row or column heading. Right-click to open the shortcut menu and add a new row.
In the image below, see how the existing row 16 is moved to row 18 after a new row is inserted.