Deleting cells and cell content

<< Click to Display Table of Contents >>

Deleting cells and cell content

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.

Deleting whole cells

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.

 

Deleting empty rows

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.

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

For more information, see the following pages.