• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Handling Unwanted Results from AutoCorrect

Q1: I need to use the text (c) in my worksheet, but Excel keeps changing it to the copyright symbol. How do I work around this?
A1: This is AutoCorrect at work. On a case-by-case basis, when AutoCorrect changes text you need left as you typed it, immediately choose Edit, Undo (or press Ctrl+Z) to restore the text. Alternatively, you can remove the item from AutoCorrect. Choose Tools, AutoCorrect. Highlight the item and click Delete. Then click OK. Do this only when you're sure you won't need the AutoCorrect entry elsewhere, however.

Unaccepting Accepted Changes

Q1: What if I accept a change, but later decide I want the original value back?
A1: Excel has no "undo change" function (as Word does). However, Excel still remembers all changes made to a cell, even after you accept a change in it. Hover your mouse over the cell to see a ScreenTip that lists all the changes. You can use this information to retype the value you want into the cell. It's unfortunate that this process isn't more automatic, but at least there is a way to restore original values.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint