Clear text, format in a cell, copy cell 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,
- click the Clear
icon at 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.
To copy a certain cell format,
- 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 top toolbar, (the mouse pointer will look like this
),
- select the cell/range of cells you want to apply the same format to.