This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
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?
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Ben Senior Germany Local time: 01:19 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
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
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.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
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.
The leading translation software used by over 270,000 translators.
Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop
and cloud solution, empowering you to work in the most efficient and cost-effective way.