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 Delete key on the keyboard.

Move the cursor to the characters you want to delete. Delete them by pressing the Fn+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 command Cmd/altOption+Delete on the keyboard.

Place the cursor to the part of the word or word that you want to delete, and press command Cmd/altOption+Fn+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 key or the Fn+Delete key combination 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 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