Forum home » Delegate support and help forum » Microsoft Excel Training and help » Tracking changes on a spreadsheet
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Tracking changes on a spreadsheet
Resolved · High Priority · Version 2003
Reply Mon 30 Jun 2008, 14:51Delegate Dianne said...
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
For upcoming training course dates see: Pricing & availability
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
|