Tracking changes in text in an Excel cell
Thread poster: Maria Helena Brenner-Kelly

Maria Helena Brenner-Kelly
United States
Local time: 22:30
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  Identity Verified
Turkey
Local time: 06:30
Member (2006)
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  Identity Verified
Denmark
Local time: 04:30
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
United States
Local time: 22:30
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:


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

Tracking changes in text in an Excel cell

Advanced search







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

More info »
SDL Trados Business Manager Lite
Create customer quotes and invoices from within SDL Trados Studio

SDL Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »



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