In Microsoft Office Excel, there are several ways to accomplish the same action. It all depends only on what is more convenient for the user. To add a cell to the sheet, you can choose the method that suits you best.
Instructions
Step 1
To add a new cell, place the cursor on the one above which you plan to add another one. Open the "Home" tab and click on the "Insert" button in the "Cells" section. If you select multiple cells horizontally and click the same button, the same number of cells above will be added as was selected. If you select them vertically, new cells will be added to the left of the selected range.
Step 2
To specify more precisely where the additional cell should be located, place the cursor on the one near which you want to add a new one, and right-click in it. In the context menu, select the second from the top of the two "Paste" commands. A new dialog box will appear. Place a marker in it opposite one of the options: "Cells, shifted to the right" or "Cells, shifted down". Click on the OK button. If you select several cells at once, the same number of new ones will be added.
Step 3
The same actions can be performed using the buttons on the toolbar. Select one or more cells and click in the "Cells" section not the "Insert" button itself, but the button in the form of an arrow located next to it. A context menu will open, select "Insert cells" in it. After that, the same window will appear, which was discussed in the second step. Mark in it the option for adding cells that suits you, and click on the OK button.
Step 4
If you have styled your table using the Table tool, you can only add new rows or columns. To be able to insert an empty cell, right-click in the table, select the "Table" item in the context menu and the "Convert to Range" sub-item. Confirm your actions in the request window. The table view will change, after that you can insert a cell in one of the ways described above.
