Technical tips

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

Hidden text is a special formatting feature of Microsoft Word which allows to hide some text from the user. In translation settings, this feature is very useful because it allows to hide text from CAT tools or convert it to non-translatable tags. This article explains how to change Word view settings to hide or show hidden text...

April 10, 2010

When you copy words and phrases inside the same Word document or from other applications, most often the text is pasted with its formatting. This formatting may be different from the formatting of the surrounding text, so the pasted text will contrast with the text around it. To avoid this, you need to paste text without formatting. Here is how to do this...

March 08, 2010

If you need to run complex find and replace operations using Word's Find & Replace dialogue, you need to clear the parameters before the next operation. Here is how to do this...

February 23, 2010
  • 1
  • 2
Page 1 of 2