Clear text, format in a cell, copy cell format
Clear format
You can quickly remove the text or the format within the selected cell. To do that,
- select a cell, a range of cells with the mouse or the whole worksheet by pressing the Ctrl+A key combination,
Note: you can also select multiple non-adjacent cells or cell ranges holding down the Ctrl key while selecting cells/ranges with the mouse.
- click the Clear
icon at the Home tab of the top toolbar and select one of the available options:
- use the All option if you wish to remove all including text, format, function etc;
- use the Text option if you wish to remove the text from the selected range of cells;
- use the Format option if you wish to clear the format of the selected range of cells. The text and functions, if present, will remain;
- use the Comments option if you wish to remove comments from the selected range of cells;
- use the Hyperlinks option if you wish to clear hyperlinks within the selected range of cells.
Note: all these options are also available from the right-click menu.
Copy cell format
You can quickly copy a certain cell format and apply it to other cells.
To apply the copied format to a single cell or several adjacent cells,
- select the cell/range of cells which format you need to copy with the mouse or using the keyboard,
- click the Copy style
icon at the Home tab of the top toolbar, (the mouse pointer will look like this
),
- select the cell/range of cells you want to apply the same format to.
To apply the copied format to multiple non-adjacent cells or cell ranges,
- select the cell/range of cells which format you need to copy with the mouse or using the keyboard,
- double-click the Copy style
icon at the Home tab of the top toolbar, (the mouse pointer will look like this
and the Copy style icon will remain selected:
),
- click single cells or select cell ranges one by one to apply the same format to all of them,
- to exit this mode, click the Copy style
icon once again or press the Esc key on the keyboard.
Return to previous page