Translation - art & business » Proofreading / Editing / Reviewing »
Tracking changes in text in an Excel cell
Thread poster: Maria Helena Brenner-Kelly
Maria Helena Brenner-Kelly
Maria Helena Brenner-Kelly
United States
Local time: 15:07
Member (2011)
English to Portuguese
Nov 26, 2011

Hello,

I am reviewing a translation in an Excel spreadsheet.

It is one of those spreadsheets with the source text in one column, the target text in the next column. Each of the cells has 15 or more lines of text.

When I tried to use Excel track changes function, it really doesn't show the changes I made. It does show a box when I pass the cursor over the cell saying I made changes to it , but the box is very small and it only says something like "changed fr... See more
Hello,

I am reviewing a translation in an Excel spreadsheet.

It is one of those spreadsheets with the source text in one column, the target text in the next column. Each of the cells has 15 or more lines of text.

When I tried to use Excel track changes function, it really doesn't show the changes I made. It does show a box when I pass the cursor over the cell saying I made changes to it , but the box is very small and it only says something like "changed from "Thank you for..." to "Thank you for...".

Has anybody have experience doing this kind of proof reading/reviewing in Excel? How do you do it? I guess I am looking for something like Work has, which shows the changes in different colors, etc?

Thanks,

Maria ▲ Collapse
 
Selcuk Akyuz
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 22:07
English to Turkish
+ ...
Comments or new column Nov 26, 2011

Hi Maria,

You can add "comments" or use a new column for your changes, recommendations or alternative translations.

Selcuk
 
Christine Andersen
Christine Andersen  Identity Verified
Denmark
Local time: 21:07
Member (2003)
Danish to English
+ ...
Maybe a little tedious, but do it in Word Nov 27, 2011

You could copy the whole column into a new document in Word.

Then make your changes in Excel, and copy the results into a new Word file.

You can use the Compare Documents function to compare the two Word files and show up the changes you have made.

This will only be for reference, and it will not be possible to reject individual changes in the Excel file, but it will show the client what you have done.

Just a suggestion.
 
Maria Helena Brenner-Kelly
Maria Helena Brenner-Kelly
United States
Local time: 15:07
Member (2011)
English to Portuguese
TOPIC STARTER
used both suggestions Nov 28, 2011

Thank you, Selcuk and Christine.

Actually, I combined both suggestions.

I created 2 new columns in Excel. One with the changes I made in Word (using track changes), and the other with edited text in final form.

I don't think the client will have any reason to complain

Thanks again,

Maria
 


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

Moderator(s) of this forum
Marco Ramón[Call to this topic]
Fernanda Rocha[Call to this topic]
Andriy Bublikov[Call to this topic]

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

Tracking changes in text in an Excel cell







Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

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

Buy now! »