Question

How do I insert a row in between 1 and 2 in excel?

Answer 1

Answer:

• Highlight row 2(left click on the entire row), the press the shift, ctrl and + keys. This will insert a row between 1 and 2

or

• After highlighting row 2 as stated above, right click and select insert. This puts a row between 1 and 2.

Explanation:

Excel has an array of rows (horizontal) and columns (vertical). The intersection of a row and a column gives a cell.

To Insert a row between 1 and 2 in excel, there are two options

• Highlight row 2(left click on the entire row), the press the shift, ctrl and + keys. This will insert a row between 1 and 2
• Alternatively, after highlighting row 2 as stated above, right click and select insert. This puts a row between 1 and 2.

Answer 2

This link should help: https://uhasct.com/insert-an-empty-row-between-each-row-of-data-in-excel/