How to insert and delete multiple cells in Excel

1. Insert cells

1. Open an Excel worksheet, as shown in the following table.

2. To insert data in a specified cell, select the target cell or cell area, as shown below.

Method 1: Right-click the selected cell and click Insert. In the displayed dialog box, click insert.

Method 2: Select Start> Insert> insert cell at the top of the menu. In the insert dialog box that appears, click OK.

Method 3: Press the Shift key and move the cursor to the lower-right corner of the selection area. When the cursor turns into a separator arrow, as shown in the figure, move the cursor to the right or down to manually.

Note: the drag distance is equal to the number of inserted cells, and the drag direction is equal to the moving direction of the active cells.

3. Click OK or drag to insert multiple cells, as shown in the figure below:

2. Delete cells

Similarly to insert, select Delete when selecting.