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

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 2Alternatively, after highlighting row 2 as stated above, right click and select insert. This puts a row between 1 and 2.