ATOI365D

#Office365Challenge – Track Changes in Excel. Here’s a quick one on Excel to take the edge off all the Content a type blogs.

Day: 136 of 365, 229 left
Tools: Excel
Description: Tracking changes in Excel

I’ve known that you can track changes in a Word for quite a long time, but I learnt this from a student of mine this week: you can switch on track changes in an Excel sheet. Yup! I didn’t know that!

When you switch on tracking, cells which have been modified will be highlighted with an indicator. When you click on the cell it will give you a summary of the changes which have been made. Take note that Excel cannot track changes on a sheet which have tables in.

To switch on “Track Changes”, click on the Review Tab > Track Changes > Highlight Changes.

TrackChanges001

A dialogue box will open where you will configure how you want the tracking to work.

TrackChanges002

Once switched on it will highlight changes with a comment box which indicates what was changed:

TrackChanges003

I know, I’m ashamed that I didn’t know this…

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Advertisements