Delete Cells

Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space. Note that the selected delete option is stored and reloaded when the dialog is next called.

To access this command...

From the menu bar:

Choose Sheet - Delete Cells.

From the context menu:

Choose Delete Cells.

From the tabbed interface:

On the Layout menu of the Layout tab, choose Delete.

From toolbars:

Icon Delete Cells

Delete Cells

From the keyboard:

+ "-"


Selection

This area contains options for specifying how sheets are displayed after deleting cells.

Shift cells up

Fills the space produced by the deleted cells with the cells underneath it.

Shift cells left

Fills the resulting space by the cells to the right of the deleted cells.

Delete entire row(s)

After selecting at least one cell, deletes the entire row from the sheet.

tip

This command is equivalent to .


Delete entire column(s)

After selecting at least one cell, deletes the entire column from the sheet.

tip

This command is equivalent to .


Please support us!