Bilingual Excel file: hide all rows where target is not empty
Thread poster: Artem Vakhitov

Artem Vakhitov  Identity Verified
Estonia
English to Russian
+ ...
Oct 19

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.

 

Alaa Zeineldine  Identity Verified
Egypt
Local time: 00:31
Member (2002)
English to Arabic
+ ...
Filter and deselect (Blanks) Oct 19

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

lzhrd8icndcs7ruhkedu.jpg


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)"

jpgeyqoa2slp1wxf5u3i.jpg

5. Click "OK", and you're done.

[Edited at 2018-10-19 22:59 GMT]


 

Soonthon LUPKITARO(Ph.D.)  Identity Verified
Thailand
Local time: 05:31
Member (2004)
English to Thai
+ ...
Setting of translation sequence Oct 20

Artem Vakhitov wrote:

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.


 

Alaa Zeineldine  Identity Verified
Egypt
Local time: 00:31
Member (2002)
English to Arabic
+ ...
To hide non-empty rows select (Blanks) only Oct 20

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

qpbkcmd32k3ezs5rof9y.jpg

5. Move to the bottom of the list and select "(Blanks)"

bzfj8snvbyecrzepyxls.jpg

6. Click "OK", and you're done.

cb49racsocmth36bxy4p.jpg

Hope this helps.

[Edited at 2018-10-20 19:35 GMT]


 

Artem Vakhitov  Identity Verified
Estonia
English to Russian
+ ...
TOPIC STARTER
Thanks everybody! Oct 20

Thanks everybody who has responded! The solution that worked for me was simply choosing the "Blank" filter for the target column.

 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Bilingual Excel file: hide all rows where target is not empty

Advanced search






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search