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 have a partially translated bilingual Excel file and need to hide all rows where the target column is not empty. How do I do that? I guess this must be a fairly common task.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Alaa Zeineldine Egypt Local time: 09:43 Member (2002) English to Arabic + ...
Filter and deselect (Blanks)
Oct 19, 2018
I tried the following and it seems to work: 1. Select the target column 2. Under "Sort & Filter" in the Home ribbon, select "Filter". The header of the target column should now show a little arrow pointing down next to a funnel icon
3. Click the little filter arrow mentioned in #2. A drop-down menu will appear 4. The bottom pane in the drop-down window shows a pre-selected list of strings that starts with "(Select All)". Move to the bottom of this list and deselect "(Blanks)"
5. Click "OK", and you're done.
[Edited at 2018-10-19 22:59 GMT]
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
I have a partially translated bilingual Excel file and need to hide all rows where the target column is not empty. How do I do that? I guess this must be a fairly common task.
By setting sequence of target segments to translate by column first, move to next column after that, resulting texts will be arrayed to respective column, next and non-blank column. This method is better applied when translating through CAT tools e.g. Trados, WordFast. Filtering of rows is not workable here, though (all rows and cells are shown).
Soonthon L.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Alaa Zeineldine Egypt Local time: 09:43 Member (2002) English to Arabic + ...
To hide non-empty rows select (Blanks) only
Oct 20, 2018
Just realized that the question was about hiding, not showing, non-empty rows. In this case, follow steps 1-3 as in my previous answer, then:
4. Click on "(Select All)" at the top of the list do deselect all strings. All selections will now be unchecked
5. Move to the bottom of the list and select "(Blanks)"
6. Click "OK", and you're done.
Hope this helps.
[Edited at 2018-10-20 19:35 GMT]
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value
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.