Tracking changes on a spreadsheet

Resolved · High Priority · Version 2003

Mon 30 Jun 2008, 14:51 Delegate 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

Tue 1 Jul 2008, 12:06 Trainer Katie said...

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

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips