Difference between revisions of "Excluding Excel Columns/Rows in Wordfast Pro"

From Wordfast Wiki
Jump to: navigation, search
Line 1: Line 1:
−
To exclude certain rows and columns in Excel files, please follow the steps:
+
To exclude certain rows and columns in Excel files, first make sure those rows and columns are hidden, then follow the steps:
  
−
# Go to '''''Preferences''''' by clicking the '''''Wordfast Pro''''' dropdown on the upper-left corner.<br>
+
# From the Project List view, go to '''''Preferences''''' by clicking the '''''Wordfast Pro''''' dropdown on the upper-left corner.
−
# Click '''''Filters''''' under 'New Project Preferences'.<br>
+
# 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>
−
# In 'Available filters', choose the filter that matches your Excel file format (such as ''.xlsm'').<br>
+
# Under “Available filters”, choose the filter that matches your Excel file format (such as ''.xlsm'').
−
# In 'Format Settings' beneath, make sure 'Skip hidden rows and columns' is ticked.<br>
+
# Under “Format Settings” beneath, make sure “Skip hidden rows and columns” is ticked.
−
# Click '''''OK''''' to save changes.<br>
+
# Click '''''OK''''' to save changes.
  
−
After creating a new project and opening  the Excel file, the hidden rows and columns won't be visible in segments.
+
After creating a new project with these settings, hidden rows and columns will not be extracted for translation.
 +
 
 +
 
 +
 
 +
== References ==
 +
<references/>
  
−
If in step 3, there is not a filter for Excel files already, click '''''Add''''' to create a new one, and finish step 4 and 5.
 
  
 
Version: Wordfast Pro 5.7<br>
 
Version: Wordfast Pro 5.7<br>

Revision as of 10:54, 1 February 2019

To exclude certain rows and columns in Excel files, first make sure those rows and columns are hidden, then follow the steps:

  1. From the Project List view, go to Preferences by clicking the Wordfast Pro dropdown on the upper-left corner.
  2. Click Filters under “New Project Preferences”.[1]
  3. Under “Available filters”, choose the filter that matches your Excel file format (such as .xlsm).
  4. Under “Format Settings” beneath, make sure “Skip hidden rows and columns” is ticked.
  5. Click OK to save changes.

After creating a new project with these settings, hidden rows and columns will not be extracted for translation.


References

  1. ↑ 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.


Version: Wordfast Pro 5.7
Operating System: macOS

--Byron, 19 January 2019

Retrieved from "https://www.wordfast.net/w/index.php?title=Excluding_Excel_Columns/Rows_in_Wordfast_Pro&oldid=4427"