A quick way to insert multiple blank cells in Excel
1. Select the range of cells in the worksheet, and then on the Start tab, in the Cells group, click the Down Triangle button on the Insert button and select the Insert Cell option in the Open Drop-down list, as shown in Figure 1.
Figure 1 Selecting the Insert cell option
2. Open the Insert dialog box, select the radio button to select the moving direction of the active cell, and then click OK to close the dialog box, as shown in Figure 2. At this point, the currently selected active cell range is moved to the right, and the same number of blank cells is inserted to the left of the selected range of cells, as shown in Figure 3.
Figure 2 Insert dialog box
Figure 3 Inserting blank cells
Attention
Select a cell or range of cells in the worksheet, hold down the Shift key and move the mouse pointer to the lower-right corner of the selection, and when the mouse cursor becomes a delimited arrow shape, drag to insert the blank cell. The distance you drag determines the number of cells you insert, and the direction you drag is the reverse of the active cell movement.