How can we help you?

Delete data using the command

To delete the data, follow these steps:

1.Specify the data to delete:

To delete a part of the data in a cell, switch to edit mode and select the required data.

To clear the content of one or more cells, select these cells.

2.On the Toolbar, in the Edit section, click t_edit_delete Delete.

In the case of filters applied or manually hidden columns or rows, only the content of visible cells is cleared.

 

 

Delete data using the keyboard keys

To delete one or more characters in a cell, use one of the following methods:

Place the cursor after the characters you want to delete. Delete them by sequentially pressing the Backspace key on the keyboard.

Move the cursor to the characters you want to delete. Delete them by pressing the Delete keyboard shortcut.

To delete a part of a word or a word in a cell, use one of the following methods:

Place the cursor after the part of the word or word that you want to delete, and press Ctrl+Backspace on the keyboard.

Place the cursor to the part of the word or word that you want to delete, and press Ctrl+Delete on the keyboard.

To delete a piece of text in a cell, follow these steps:

1.Select the required text.

2.Press the Delete or Backspace on the keyboard.

To clear the content of the cells, follow these steps:

1.Select the cell or range that needs to be cleared of data.

2.Press the Delete or Backspace key on the keyboard.

In the case of filters applied or manually hidden columns or rows, only the content of visible cells is cleared.

 

Was this helpful?
Yes
No
Previous
Find and replace