Question

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

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

Explanation: