Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a spreadsheet I need to edit and would like to be able to make all my edits in red so I know what has been modified.

Is there a way I can do this without having to format each cell as I go?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Here are instructions on how to turn on Change Tracking To turn on change tracking, follow these steps:

  1. Select ReviewTrack ChangesHighlight Changes. The Highlight Changes dialog box appears.

  2. Turn on the Track changes while editing checkbox. When you turn on change tracking, you also automatically switch on workbook sharing a separate feature. There’s no way to turn on change tracking without also turning on workbook sharing.

  3. Ignore the Who, When, and Where checkboxes for now, and click OK to return to your worksheet.

More information can be found on GeekDeck.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.