Alexandra Birovescu

You won't be able to do this automatically unless you rearrange the content to be in single columns and then put everything back afterwards.  Not sure how labour intensive that would be, but the automated QA checks might make the prep time worth it?

Alternatively take a another look at the Bilingual Excel and do something like this:

If you use the DSI Viewer application from the appstore you can see this information in real time in Trados Studio as you work.  Then you just have to compare the segment counts against this info in front of you and at least you don't have to keep referring to Excel and see where you are.  Might be good even though you will need to do this for each column separately unless you move into one column.

Alexandra Birovescu

... sorry, another solution if you're feeling technical is to convert the Excel to XML.  Then you may be able to create a custom filetype to handle this for you.  This article refers:

https://multifarious.filkin.com/2014/05/02/xml-length-restrictions/

At least the article explains how to handle this in XML and this does offer more flexibility.  But you'll have to manage the Excel -> XML -> Excel yourself.