Excluding Excel Columns/Rows in Wordfast Pro - Revision history

David Daduč at 08:28, 14 April 2021

2021-04-14T08:28:56Z

David Daduč: David Daduč moved page Excluding Excel Columns/Rows in Wordfast Pro 5 to Excluding Excel Columns/Rows in Wordfast Pro

2021-04-14T07:59:20Z

David Daduč moved page Excluding Excel Columns/Rows in Wordfast Pro 5 to Excluding Excel Columns/Rows in Wordfast Pro

Byron at 05:24, 4 February 2019

2019-02-04T05:24:08Z

Byron at 05:21, 4 February 2019

2019-02-04T05:21:55Z

Byron at 05:13, 4 February 2019

2019-02-04T05:13:57Z

Byron at 05:12, 4 February 2019

2019-02-04T05:12:03Z

John at 09:59, 1 February 2019

2019-02-01T09:59:12Z

John at 09:54, 1 February 2019

2019-02-01T09:54:14Z

John at 05:31, 29 January 2019

2019-01-29T05:31:12Z

Byron at 20:39, 19 January 2019

2019-01-19T20:39:25Z

@@ Line 1: / Line 1: @@
-To exclude certain rows and columns in Excel files, first make sure those rows and columns are hidden, then follow these steps:
+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''''' by clicking the '''''Wordfast Pro''''' dropdown on the upper-left corner.
+# 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'').
@@ Line 9: / Line 9: @@
 [[File:Hide Columns in Excel.png]]
-For complex Excel files, you can also use an XML configuration file to specify columns/rows to be translated. See the [[Translating Excel Files with Wordfast Pro 5]] article for more information.
+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]]

@@ Line 7: / Line 7: @@
 # Click '''''OK''''' to save changes.
-[[File:Hide_Columns_in_Excel.jpg]]
+[[File:Hide Columns in Excel.png]]
 After creating a new project with these settings, hidden rows and columns will not be extracted for translation.

@@ Line 7: / Line 7: @@
 # Click '''''OK''''' to save changes.
-[[File:Hide Columns in Excel.jpg]]
+[[File:Hide_Columns_in_Excel.jpg]]
 After creating a new project with these settings, hidden rows and columns will not be extracted for translation.

@@ Line 7: / Line 7: @@
 # Click '''''OK''''' to save changes.
-[[File:Example.jpg]]
+[[File:Hide Columns in Excel.jpg]]
 After creating a new project with these settings, hidden rows and columns will not be extracted for translation.

@@ Line 6: / Line 6: @@
 # In “Format Settings” box, make sure “Skip hidden rows and columns” is ticked.
 # Click '''''OK''''' to save changes.
 After creating a new project with these settings, hidden rows and columns will not be extracted for translation.

← Older revision	Revision as of 07:59, 14 April 2021
(No difference)

@@ 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.
 Version: Wordfast Pro 5.7<br>