Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 2 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .