Deleting cells and cell content

<< Click to Display Table of Contents >>

Deleting cells and cell content

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.

Deleting whole cells

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.

 

Deleting empty rows

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.

Deleting duplicate 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 dropdown_arrow | Remove duplicate rows.

For more information, see the following pages.