– How to Insert an Empty Row
– How to Insert a Row with Formatting Same as Above
– How to Insert a Row with Formatting Same as Below
When working with an Excel spreadsheet, you may need to insert a row with contents. Please follow the steps below for details:
Step 1: Copy the row (or rows) with contents;
Step 2: Click the first cell on the left in the row below the new row you want to insert (or click the whole row);
Step 3: Right click and select "Insert Copied Cells" from the list in the dialog box;
Step 4: Select "Shift cells down" in the new dialog box;
Step 5: The new row is now in the table.
Alternatively, please use the commands in the ribbon:
Step 1: Copy the row or rows, and click the "Home" tab from the ribbon;
Step 2: Click "Insert", and select "Insert Copied Cells" from the drop-down list;
Please note: if you copied the whole row and click any cell other than the first cell on the left, you will receive a warning message: "You can't paste this because the Copy area and the paste area aren't the same sizes…".
