* Logo
* Translator Tools
*
* Motto
* *
TransTools suite Knowledge base Feedback Back to Index | Site map
*
*
*
*
**
**
***
***
***
**
**
*
*
*
*
*
*
Bookmark and Share
*

Remove Highlight

Excel
Category: TranslationBack to Replace section

Undo Undo support - YES. See general Excel undo notes.

When the worksheet has been processed with Multiple replace command and checked by the translator, it's time to remove highlights used to mark the replaced cells. This is where Remove Highlight comes in – it removes all highlights of a particular colour (as specified in the Options dialogue below).

Options:

Screenshot: Remove Highlight dialogue

  1. Entire worksheet - select this option if you would like to remove highlights of a chosen color from cells and textboxes on the active worksheet.
  2. Selection - select this one if you want to remove highlights of a chosen color from the selection only. The selection may be a range of cells or a shape / several shapes.
  3. Highlight color - pick a desired colour from the list of predefined colours. If the background colour of a cell or textbox matches the chosen colour, it will be reset to 'No colour' (White / Transparent). This should be the same colour as the one specified in Multiple replace options.

Notes:

  • Caution must be taken to select the same colour as the colour used when the document was checked with Multiple replace command. Otherwise, it is possible that other highlights (perhaps those made by the original author of the document, which must be left intact) will be removed.
  • Sometimes original background colours (i.e. author's formatting) will be changed to new colours by Multiple replace command. To restore the original background colours, consult the original document.
 
Developed by Stanislav Okhvat, 2007-2010

Microsoft Word®, Excel®, Powerpoint® and Visio® are registered trademarks of Microsoft Corporation.
Autocad© is copyright of Autodesk, Inc.
SDL Trados® (including Trados Workbench, TagEditor and Microsoft Word Addin) is a registered trademark of SDL plc.
Wordfast© is copyright of Yves Champollion.

Software disclaimer