Question

Insertion can be done by shifting the cells or ​

Answer 1

Explanation:

Step 1. Choose the cell or numbers of cells where you want to add new cells. Meaning if you want to add ten new cells then select ten cells on the worksheet.

Step 2. If you want to terminate any selection then simply click on any cell from the worksheet to cancel the selection.

Step 3. Next, go to the Home tab and click on "Insert" from the Cells category.

Step 4. Now, click on "Insert Cells" to continue.

Step 5. You will have to choose in which direction you want to push the surrounding cells and click on insert.

Alternatively, you can select a cell or a range of cell and then right-click and click on "Insert". After you finish up the settings, you should be able to see that the new cells are inserted on the exact position that you have selected and the surrounding cells are shifted according to the command you have set.