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,

  1. select a cell, a range of cells with the mouse or the whole worksheet by pressing the Ctrl+A key combination,
  2. click the Clear 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,

  1. select the cell/range of cells which format you need to copy with the mouse or using the keyboard,
  2. click the Copy Style Copy Style icon at the top toolbar, (the mouse pointer will look like this Mouse pointer while pasting style),
  3. select the cell/range of cells you want to apply the same format to.