Ways to insert multiple rows or columns at once in an Excel worksheet

ways to insert multiple rows or columns at once in an Excel worksheet

1, in the worksheet at the same time select multiple lines, such as the selection of 3 lines here. Right-click to select the Insert command on the shortcut menu to insert and select rows with the same number of rows before selecting rows, as shown in Figure 1.

Figure 1 Inserting multiple rows at the same time

2. At this point, the Insert Option button appears at the beginning of the insertion, clicking the Down Triangle button on the button, and selecting the corresponding radio button in the Open Drop-down list, you can set the format of the inserted row, as shown in Figure 2.

Figure 2 Formatting the insert row

Attention

Users can also insert rows or columns in a worksheet by clicking the Insert button directly in the Cells group on the Start tab. After you select a row or column, press the ctrl+shift+= key to quickly insert rows or columns in the worksheet.