This would insert the new row by shifting the current 6 th row to the seventh row. Step 2: Press the shortcut key ALT + I + R to insert a row.You just select the cell where you want to insert a new row. Step 1: Place the cursor on the A6 cell and press the shortcut key ALT + I + R to insert a row.#3 Insert Row Using Excel Shortcut Key ALT + I + R Choose the suitable option according to your requirements. Step 2: It will show you the option of whether you want to insert the new row by shifting cells to the right or shifting cells down or an entire row or an entire column.Once you click on the shortcut key, it will open up the below dialog box. Step 1: Place the cursor on the A6 cell and press the shortcut key Ctrl +.#2 Insert Row Using Shortcut Key Ctrl + and Dialog Box Based on the format you have selected, it will format the newly inserted row. Suppose you want to the newly inserted row to be formatted as the above one or below one or no formatting. This drop-down includes all the formatting styles.Click on the drop-down of the brush to see the options. If you notice, there is a small format option with the Brush symbol.This has inserted the new row instantly.As soon as the entire row is selected, press Ctrl + (plus sign).Once you have clicked this shortcut key, it will select the entire row for you. Place the cursor on the A6 cell and select the 6 th row by using the shortcut key Shift + Space.
