Excel Track Changes Viewing Problem

[Guest]

I am using Excel for written and not numeric data. Some of my cells have
quite a bit of text in them. With track changes on, I have made some textual
changes and I cannot read the entire changes in the track changes box. Is
there any way to enter this box and be able to read all of the tracked
changes?

 

[Bryan Hessey]

Whilst MS Word, Tables or Columns handles written data, and certainly
the track changes, much better, you can list all changes that have been
made in Excel.
Select Tools, Track Changes, Highlight Changes, and untick When, Who
Where and tick List Changes to New Sheet.

This should give a better view.

Hope this helps.

--