How to Make Blank Rows Between Populated Rows in Excel

1. Double-click the Excel file into which you want to insert a new row to open the file in Excel 2010.
2. Click the row heading at the left side of the window for the bottom row of the pair that you want to split. For example, if you want to insert a row between rows 1 and 2, click the number '2' at the left side of the window. After clicking the row heading, the entire row should be highlighted in blue.
3. Click the 'Home' tab at the top of the window.
4. Click the 'Insert' drop-down menu in the Cells section of the ribbon at the top of the window.
5. Click 'Insert Sheet Rows.'