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 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,

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 icon at the Home tab of the top toolbar, (the mouse pointer will look like this ),
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 icon at the Home tab of the top toolbar, (the mouse pointer will look like this and the Copy style icon will remain selected: ),
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 icon once again or press the Esc key on the keyboard.

Return to previous page