Delete data

To delete the data, follow the steps below:

1.Specify the data to delete:

•To delete part of the data in a cell, enter the cell editing mode and select the required data.

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

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

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. If you are working in Windows or Linux, delete characters by pressing Backspace as many time as needed, if you are working in macOS, delete them by pressing Delete.

•Place the cursor before the characters you want to delete. If you are working in Windows or Linux, delete characters by pressing Delete as many time as needed, if you are working in macOS, delete them by successively pressing Fn+Delete keys.

To delete a word or its part in a cell, do one of the following:

•Place the cursor after a word or word part that you want to delete. When working in Windows or Linux, press Ctrl+Backspace. When working in macOS, use  Cmd+Delete or  Option+Delete shortcut.

•Place the cursor before a word or word part that you want to delete. When working in Windows or Linux, press Ctrl+Delete. When working in macOS, use  Cmd+Fn+Delete or  Option+Fn+Delete shortcut.

To delete some text in a cell, do the following:

1.Select the desired text.

2.When working in Windows or Linux OS, press Delete or Backspace. When working in macOS, press Delete or use Fn+Delete shortcut.

To clear the content of the cell, do the following:

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

2.When working in Windows or Linux OS, press Delete or Backspace. When working in macOS, press Delete.