Clear data

Use the Clear command on the Home tab, in the Edit group, to remove data or formatting from cells, returning them to their default settings.

Clear data or formatting

1.Select a cell or range of cells.

2.Click Clear button and select the desired clear option from the list.

Clear options

–Clear all: removes all content (text, formulas, links), formatting, notes, and hyperlinks. Merged cells are separated.

–Clear formatting: resets cell formatting to default, preserving cell contents. Merged cells are separated.

–Delete contents: Deletes text, formulas, and other data, preserving cell formatting and notes.

–Delete notes: removes only notes associated with cells.

–Delete links: removes hyperlinks, leaving text without color selection and underlining.

In the current version of the application, comments are not deleted when using the Clear command.

Hotkeys

To quickly apply the Clear formatting command, press the keyboard shortcut Ctrl+Space (Cmd+Space).