How to translate only cells highlighted yellow in Excel file?

Question

My client sent me for Excel files and told me to translate only the cells that he has highlighted yellow . If this were a Word document, I could use a handy tool in TransTools to automatically hide everything highlighted yellow, and then import it. However, TransTools doesn't work on Excel files (I emailed Stanislav to confirm this). Are there any clever tricks or SDL Apps to solve this problem? 
 
 Michael

Michael Beijer · Answer

OK, I think I discovered a workaround, which I'm going to try. No idea if it will work though, so if you're reading this and know they won't, please warn me! ;-) 
 
 1. Select piece you wish to hide 
 2. Right-click: Format Cells 
 3. Switch Category from "General" to "Custom" 
 4. Type ";;;" over "General" 
 5. Press OK 
 
 This will hide the cells so they are no longer imported into your CAT tool. 
 
 Once you've finished translating and exported your final documents, remember to un-hide them by selecting the same cells and changing the Category "Cusom" back to "General". 
 This will obviously only work well if your cells are easy to identify visually, because if they are not you will have a very hard time un-hiding them all afterwards. 
 
 Michael

Trados Studio > 1. Trados Studio

How to translate only cells highlighted yellow in Excel file?