Dianne has attended:
Excel Intermediate course
Tracking changes on a spreadsheet
I share a spreadsheet with someone over seas who is forever changing figures on my side of our intercomapny, i have forgotten how to go about reviewing all the changes made to the sheet when i recieve it back rathe than re-reconcille the whole thing!!
PLease help!
Dianne
RE: Tracking changes on a spreadsheet
Hi Dianne,
Thank you for yor question.
To track changes on Excel 2003, you will need to switch on the feature on TOOLS menu > Track Changes > Highlight Changes.
In the Highlight Changes window, you may choose to review a particular user's changes then on the spreadsheet you can choose to accept / reject each individual changes.
All changed cells are highlight with a dark blue tag.
Hope this is useful.
Kind regards,
Katie Woo
Microsoft Certified Trainer
