Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close

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,

  1. 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.

  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.

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,

  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.

To apply the copied format to multiple non-adjacent cells or cell ranges,

  1. select the cell/range of cells which format you need to copy with the mouse or using the keyboard,
  2. double-click the Copy Style Copy Style icon at the top toolbar, (the mouse pointer will look like this Mouse pointer while pasting style and the Copy Style icon will remain selected: Multiple copying style),
  3. click single cells or select cell ranges one by one to apply the same format to all of them,
  4. to exit this mode, click the Copy Style Multiple copying style icon once again or press the Esc key on the keyboard.
Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action