Question

how many rows should you select to insert 3 blank rows​

Answer 1

Answer:

Insert Multiple Blank Rows in Excel by selecting Rows

For example, I want to insert 6 rows after row 3, then hover the mouse pointer at row 3 (You can see the black arrow) and select the row. Next, click and hold the left mouse button and select 6 rows. Now, right-click on the selected area and select 'Insert' option.

Answer 2

Answer:

Insert Multiple Blank Rows in Excel by selecting Rows

For example, I want to insert 6 rows after row 3, then hover the mouse pointer at row 3 (You can see the black arrow) and select the row. Next, click and hold the left mouse button and select 6 rows. Now, right-click on the selected area and select 'Insert' option

☺️☺️