Alternatively, you can click on Home tab and then click on ' Insert' from the Cells group category. Select the row and right-click on it and click on ' Insert'. After that, follow this instruction to insert a new row. For example, if you want to insert a row above row right then select the eighth row or a cell in the eighth row. If you want to insert a new row then first you will have select the row or a cell in a row above where you want to insert the new row.

Part 2: How to Insert New Rows on A Spreadsheet 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. 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.

How to add cells in openoffice excel