how to add multiple rows in excel shortcut

From the drop-down menu, choose Row above.Īs a result, a new row is added, and the other cells are shifted down.To insert a new row and shift the row(s) of cells downward in Google Sheets, select the cells in the highest row you want to shift downward.In Google Sheets, start by choosing where you want the new cells to be, rather than where the old cells should go. This saves time over having to type a comma after each cell selection. You can hold down the Ctrl key while selecting cells to add to the CONCATENATE formula. Insert and Shift Cells Down in Google Sheets Option 1: Ctrl+Left-click to Select Multiple Cells. For an entire column, it shifts cells right. Note : When you insert an entire row, Excel automatically shifts cells down. As a result, three rows are added above them. In the Insert dialog window, choose Shift cells down, and then click OK.Īs a result, the new rows are added, and the other cells are pushed down.Then right-click the selection and from the drop-down menu, choose Insert…

To add multiple rows at once and shift cells downward, select multiple rows (here, use A2:C4 to add three rows at once).In it choose Shift cells down, then click OK.Īs a result, a new row is added, and the current data is pushed down.Īdd Multiple Rows at Once and Shift Cells Down First, select the cells in the highest row you want to shift downward (here, A2:C2), then right-click and from the drop-down menu, choose Insert….There is an easy way to shift row(s) of cells downward. This tutorial demonstrates how to shift cells down when inserting in Excel and Google Sheets.

How to add multiple rows in excel shortcut