Technical forums » Office applications »
Creating bilingual XLS files with multiple tabs
Thread poster: Jean-Christophe Duc
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 05:21
English to French
+ ...
Sep 19, 2016

I am looking for a solution to facilitate the translation of XLS files with multiple tabs.
So far the only solution I have found is to translate the file in Studio or whatever, then to copy the translation beside the English column.
This is OK when there is one or two tabs, but as soon as there more, it becomes complicated.
Any ideas?
 
Ben Senior
Ben Senior  Identity Verified
Germany
Local time: 05:21
German to English
Hide a column Sep 19, 2016

If you copy the source column into the target column and then hide the source column, you can then translate the file in your CAT tool. Afterwards just unhide the source column and you have the bilingual worksheet.

Ben
 
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 05:21
English to French
+ ...
TOPIC STARTER
thanks Sep 19, 2016

Do you mean the "hide column" command in Excel?
Can it be "unhidden" afterwards?
 
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 05:21
English to French
+ ...
TOPIC STARTER
Hidden columns Nov 21, 2016

For info, the command to "unmask" the Excel columns is buried into the Home tab, Cell group -> Hide / Unhide.
And yes, creating two columns and hiding one remains the easiest way to generate bilingual Excel files. It is probably possible to create a macro for this.
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Creating bilingual XLS files with multiple tabs






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »