Difference between revisions of "Excluding Excel Columns/Rows in Wordfast Pro"
(Created page with "To exclude certain rows and columns in Excel files, please follow the steps: 1. Go to '''''Preferences''''' by clicking the '''''Wordfast Pro''''' dropdown on the upper-left...") |
David Daduč (talk | contribs) |
||
| (12 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | To exclude | + | When you translate an '''Excel file''', [[Wordfast Pro]] (WFP) allows you to exclude selected rows or columns. To exclude them, follow these two steps: First, make sure the not-to-be-translated rows or columns are '''hidden in the Excel file'''. Second, make sure the required setting is activated WFP: |
| − | + | # From the “Project List” view, go to '''''Preferences''''' [[File:WFP Preferences icon.png|25x25px|WFP Preferences icon]]. | |
| − | + | # Click '''''Filters''''' under “New Project Preferences”.<ref>Note that any changes made under “New Project Preferences” will only affect future projects. If you want to change the preferences of an existing project, you need to open the project first, then modify preferences under “Current Project Preferences”. Furthermore, when re-using a project as a template during the project creation wizard, the project being created will inherit the preferences of the re-used project.</ref> | |
| − | + | # Under “Available filters”, choose the filter that matches your Excel file format (such as ''.xlsm''). | |
| − | + | # In “Format Settings” box, make sure “Skip hidden rows and columns” is ticked. | |
| − | + | # Click '''''OK''''' to save changes. | |
| − | + | [[File:Hide Columns in Excel.png]] | |
| − | |||
| − | + | After you create a new project in WFP, hidden rows and columns will not be extracted for translation from Excel files. For '''complex Excel files''', you can also use an [[Translating Excel Files with Wordfast Pro|'''XML configuration file''' to specify columns/rows to be translated]]. | |
| − | |||
| − | + | == References == | |
| + | <references/> | ||
| + | |||
| + | [[Category:Wordfast Pro]] | ||
Latest revision as of 09:28, 14 April 2021
When you translate an Excel file, Wordfast Pro (WFP) allows you to exclude selected rows or columns. To exclude them, follow these two steps: First, make sure the not-to-be-translated rows or columns are hidden in the Excel file. Second, make sure the required setting is activated WFP:
- From the “Project List” view, go to Preferences
. - Click Filters under “New Project Preferences”.[1]
- Under “Available filters”, choose the filter that matches your Excel file format (such as .xlsm).
- In “Format Settings” box, make sure “Skip hidden rows and columns” is ticked.
- Click OK to save changes.
After you create a new project in WFP, hidden rows and columns will not be extracted for translation from Excel files. For complex Excel files, you can also use an XML configuration file to specify columns/rows to be translated.
References
- ↑ Note that any changes made under “New Project Preferences” will only affect future projects. If you want to change the preferences of an existing project, you need to open the project first, then modify preferences under “Current Project Preferences”. Furthermore, when re-using a project as a template during the project creation wizard, the project being created will inherit the preferences of the re-used project.
