There are two methods for deleting data from a worksheet:
▪Deleting the content of cells
| If you use the Del key on the keyboard, only the contents of the selected cells will be deleted. |
| If you use the ribbon command Home | group Cells | Delete, however, the selected cells will be completely deleted from the worksheet. The other cells in the worksheet will move up accordingly. |
In addition, PlanMaker provides two commands specifically for deleting empty rows and duplicate rows:
FreeOffice: These two commands are not included in SoftMaker FreeOffice.
| To delete all empty rows within a certain range of rows, select these rows, and then choose the ribbon command Data | group Edit | Remove empty rows. |
To delete all duplicate rows within 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.