There are two methods for deleting data in a worksheet:
▪Deleting the content of cells
| If you use the Del key on the keyboard, only the contents of the selected cells are removed. |
| However, if you use the ribbon command Home | group Cells | Delete, the selected cells are completely deleted from the worksheet. The other cells move up to take their space. |
In addition, PlanMaker offers two commands especially for deleting empty rows and duplicate rows:
FreeOffice: These two commands are not included in SoftMaker FreeOffice.
| To delete all empty rows in a certain range of rows, select these rows and then click the ribbon command Data | group Edit | Remove empty rows. |
To delete all duplicate rows in a certain range of rows, select these rows and then choose the ribbon command Data | group Edit | Remove empty rows  | Remove duplicate rows. |
For more information, see the following pages.