AVS4YOU >> AVS Document Editor >> Clear text, format in a cell, copy cell format

Powered by

AVS Document Editor
This page is available in EnglishFrançaisDeutschItalianoEspañol
AVS Document Editor
Download
AVS Document Editor
Current Version:  4.2.3.302
Release Date:  12/27/2016
File Size:
125.17 MB

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.
Download AVS Document Editor Current Version:  4.2.3.302File Size: 125.17 MB

Please note that AVS4YOU programs do not allow you to copy protected material. You may use this software in copying material in which you own the copyright or have obtained permission to copy from the copyright owner.

AVS4YOU is a registered trademark of Online Media Technologies, Ltd., UK. Intel and Core 2 Duo are registered trademarks of Intel Corporation. AMD and Athlon X2 are registered trademarks of Advanced Micro Devices, Inc. Windows 10/8.1/8/7/XP/2003/Vista are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners.