Technical tips, articles and workflows for translators

Version 3.14.1 of TransTools has been released. This version includes an important change that affects the way TransTools for AutoCAD generates translation tables in Microsoft Word and Excel formats...

March 07, 2017

Version 3.14 of TransTools has been released. It includes several improvements in TransTools for Word: new options for Autoformat command (Document Cleaner), minor improvements in Dual Language Document Assistant, bug fixes in Tag Cleaner, and more.

February 24, 2017

Screenshot: Strange symbol exampleAs translators, we deal with written text all the time. In the digital world, text is represented using the Unicode standard which encodes the individual graphemes of all written languages and can be considered the Bible for anyone dealing with electronic text. And since the job of the translator is to transpose text from one language to another, we must use the proper Unicode symbols to do that. In this article, you will learn how to identify any Unicode symbol that you encounter in electronic documents in order to decide whether it should be retained, removed or replaced in the translation...

January 20, 2015
Continue reading "What is this symbol?"

Article imageWhat makes Microsoft Excel so powerful is its ability to handle formulas. Most formulas do not require translation as they produce a number. However, from time to time you will come across an Excel spreadsheet with text formulas, i.e. formulas that produce translatable text.

November 06, 2012

Knowing your Windows user name allows you to navigate to various user folders. Here is how you can quickly get your Windows user name...

June 12, 2011

If you use Excel to manage any data, for example glossaries, you will need to sort this data sooner or later. This article explains how to do this.

May 09, 2011

When you translate Excel spreadsheets, you will often see some cells with partially invisible text. This is because for some cells Excel does not expand row height to cell text automatically. This article explains how to make rows adjust their height to the contents automatically...

May 01, 2011

When you translate Excel spreadsheets or otherwise change cell values, you may discover that some text becomes partially hidden as it runs into the cells on the right or flows beyond the printable page extents. This occurs because word wrap for this particular cell is deactivated. Read this article to find out how to activate word wrap for individual cells or cell ranges...

March 08, 2011

If you need to clear background color of cells and textboxes in Excel spreadsheets (before delivery to the customer and in many other situations), follow these instructions...

February 23, 2011

Using the keyboard instead of the mouse is one of very effective ways to increase productivity. This article explains how to assign a key combination to a standard Microsoft Word command or a custom Word macro...

May 09, 2010

Article imageIf you want to find text in Microsoft Word, you may be tempted to click Find button in Word ribbon, or press Ctrl+F. This opens the Navigation Pane which is not convenient for finding text. Instead, I recommend you to use Find & Replace dialogue...

May 01, 2010

Translating Excel spreadsheets is pretty easy. All you need to do is translate text in individual cells and then format the spreadsheet for the target language user. However, sometimes your spreadsheet will contain charts, making translation more complicated. This article will help you understand and master charts so you can easily translate even the most advanced varieties...

April 18, 2010
Page 2 of 3