8.2. Review Mode

Use review mode to review and correct your translations. In review mode, you look up cells just like in translation mode, except in this case you’re looking up translations instead of source segments.

If you make a correction to the translation in a cell (or textbox), add the translation to Felix by pressing Alt + . This will correct the original translation unit (TU) in your translation memory.

Switch to review mode button

To enter review mode, click on the half-green, half-white button on the right-hand side of the toolbar. To switch back to translation mode, click this button again.

When you’re in translation mode, an asterisk (*) appears next to the menu, and the colors of the toolbar buttons are inverted.

Excel review mode toolbar

Excel toolbar in review mode

8.2.1. Look up a Translation

Select the cell you wish to look up. Then select Felix ‣ Lookup from the menu, or press Alt + L. The translation in your TM matching the cell’s contents will appear in Felix.

Note that unlike Word, formatting information is not preserved for Excel queries.

If a text box is selected, then the contents of the text box will be looked up.

Toolbar button Look up current selection
Menu command Lookup
Keyboard shortcut Alt + L

8.2.3. Correct a Translation

If the translation needs to be changed, make any corrections, then navigate to another cell (e.g. by pressing the Enter key), and navigate back to the cell you wish to correct (this is because what you type isn’t finalized until the cell loses focus). From the Felix menu, select Set (or press Alt + ↑).

Alternatively, you can select Set and Next (or press Alt + S); this will register the current cell, and look up the next one (scanning left-to-right, top-to-bottom until a cell with text is found or a maximum number of cells has been searched).

8.2.3.1. Correct the translation of the current cell

Toolbar button Lookup
Menu command Correct Translation
Keyboard shortcut Alt +

8.2.3.2. Correct translation and look up next cell

Toolbar button Correct and Next
Menu command Correct and Next
Keyboard shortcut Alt + S

8.2.4. Look up the Next Translation

From the Felix menu, select Lookup Next, or press ALT + →.

Toolbar button Look up Next
Menu command Look up Next
Keyboard shortcut Alt +

8.2.5. Restore a Translation from the Memory

Select the cell into which you wish to retrieve the current suggestion from Felix. From the Felix menu, select Get (or press Alt + ↓).

Alternatively, you can select Get and Next (or press Alt + G); this will restore the current translation, and look up the next one (scanning left-to-right, top-to-bottom until a cell with text is found or a maximum number of cells has been searched).

8.2.5.1. Restore the translation, and look up the next cell

Toolbar button Look up Next
Menu command Restore Next
Keyboard shortcut Alt + G

8.2.5.2. Restore the translation

Toolbar button Look up Next
Menu command Restore
Keyboard shortcut Alt +

8.2.6. Auto Reflect Edits

If you’re using the Translation History feature (see :ref:` excel-trans-history`), you can make edits to your translation, and then automatically reflect all your edits with a single operation.

To use this function, select Felix ‣ Auto Reflect Edits...:

Sheet
The current worksheet
All Workbooks
All open workbooks