Here's a quick Excel tip you might not know. In this video, I will show you how to add multiple blank rows into your Excel spreadsheet.
1 Select the number of rows that you want to add.
2 Right-click on the selected rows.
3 Choose “Insert” from the context menu.
4 The selected number of blank rows will be inserted above the selected rows.
1 Select the cell where you want to add the blank rows.
2 Right-click on the selected cell.
3 Click on “Insert” in the context menu.
4 Select “Entire Row”
5 The blank rows will be inserted above the selected cell.
1 Select the cell where you want to add the blank rows.
2 Press Ctrl+Shift+”+”
3 The blank rows will be inserted above the selected cell.
Note: You can also use the above steps to add multiple blank columns by selecting “Entire Column” instead of “Entire Row” in step 4.