|
<< Click to Display Table of Contents >> Inserting new cells |
The ribbon command Home | group Cells | Insert
inserts new cells, rows or columns in a worksheet.
If you choose this command, the program displays a dropdown menu in which you can select how to insert the cells.
The following options are available:
▪Insert cell, move cells down
| The program inserts the exact number of cells as were selected before choosing this command. If nothing was previously selected, only one cell will be inserted. |
| The cells below the insertion will be moved down. |
▪Insert cell, move cells to the right
| The program inserts the exact number of cells as were selected before choosing this command. If nothing was previously selected, only one cell will be inserted. |
| The cells to the right of the insertion will be moved further to the right. |
▪Insert complete rows
| PlanMaker will insert as many complete rows as were included within the selection. If nothing was previously selected, only one row will be inserted. |
| The rows below the insertion will be moved down. |
▪Insert complete columns
| PlanMaker will insert as many complete columns as were included within the selection. If nothing was previously selected, only one column will be inserted. |
| The columns to the right of the insertion will be moved further to the right. |
Note: When inserting new cells, the cell formatting of the previous row/column is applied to them. Furthermore, when inserting complete rows/columns, the row height/column width of the previous row/column is also applied to them.
The dropdown menu of the command Insert
also contains the following options:
▪Insert copied cells, see next section
▪Insert worksheet, see Creating new worksheets