Hello Paloma Benlloch ,

Perhaps the solution here is to use colour in the selected cells.

In Studio, you have the option of excluding cells (or including cells) with a selected colour

There is an excellent article by Emma Goldsmith which I think you will find useful.

https://signsandsymptomsoftranslation.com/2019/05/15/excel-cells-in-studio/

Thank you very much, . 

I've run a couple of tests with this idea, but it still doesn't seem to quite work the way we want it to. As some cells (not all of them, though), colored in the chosen shade, seem to still get extracted for translation.

This is an awesome idea for a different project, but it wouldn't quite work in this case, as it would add an extra step to our process: we would have to manually change the chosen color again after translation so we could return the spreadsheet to its original format, a task that would be quite time-consuming for us and not very efficient in this particular case as we have many different sheets. 

Do you know if there is another less "invasive" way to exclude certain cells?

Thank you very much in advance. 

Thank you very much, . 

I've run a couple of tests with this idea, but it still doesn't seem to quite work the way we want it to. As some cells (not all of them, though), colored in the chosen shade, seem to still get extracted for translation.

This is an awesome idea for a different project, but it wouldn't quite work in this case, as it would add an extra step to our process: we would have to manually change the chosen color again after translation so we could return the spreadsheet to its original format, a task that would be quite time-consuming for us and not very efficient in this particular case as we have many different sheets. 

Do you know if there is another less "invasive" way to exclude certain cells?

Thank you very much in advance. 

Hi Paloma Benlloch,

I use this feature quite often to exclude columns in Excel and it has never failed. When I thought it did, it was actually that I had set a slightly different shade of the color.

To set the original color back to the cells you can use the Format Painter tool and apply the formatting to the whole sheet at once:

Hi Jesús Prieto! 

Thank you very much for your answer! That's a wonderful trick. I hadn't thought of using the Format Painter tool on the whole sheet at once. It's quite helpful. 

Regarding the exclusion of columns by shade, I think it may have had to do with the formating of certain cells on our test file. We'll keep trying it out as it seems that the general consensus among the Studio community is that it works pretty much all the time. 

Thank you once again for your help.