Quick EXCEL tip how to add multiple blank rows into your Excel spreadsheet.
Jan 24, 2023 1:00 AM

Quick EXCEL tip how to add multiple blank rows into your Excel spreadsheet.

External YouTube Channel

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. WATCH ME NEXT ✅️ Stop us

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.

To add multiple blank rows into an Excel spreadsheet, you can use the following steps:

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.

Alternatively, you can also use the following steps:

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.

or

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.