January 7, 2014

Track changes in Microsoft Excel 2010

Many of us have probably used the track changes tool in Microsoft Word, but did you know that you can use this tool in Excel as well?  This can be very beneficial when sharing documents between coworkers and such.  To find this tool click on the Review tab, and in the Changes group click Track Changes.  In the pop up window that opens, mark the box next to Track Changes While Editing.  Then use the information in the rest of the window to set the factors of which changes to highlight.  Once you have clicked Ok you will be prompted to save your workbook.  Now when sharing your workbook you can see exactly what has or hasn’t been changed.

No comments:

Post a Comment