You will have to choose in which direction you want to push the surrounding cells and click on insert.Īlternatively, you can select a cell or a range of cell and then right-click and click on ' Insert'. Now, click on ' Insert Cells' to continue. Next, go to the Home tab and click on ' Insert' from the Cells category. If you want to terminate any selection then simply click on any cell from the worksheet to cancel the selection. Meaning if you want to add ten new cells then select ten cells on the worksheet. Choose the cell or numbers of cells where you want to add new cells. Part 1: How to Insert New Cells on A Spreadsheet Part 3: How to Insert New Columns on A Spreadsheet.Part 2: How to Insert New Rows on A Spreadsheet.Part 1: How to Insert New Cells on A Spreadsheet.
