• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Excel Essentials > Secrets of the Office Masters: Beware of Undo

Secrets of the Office Masters: Beware of Undo

Like all Office applications, Excel includes an Undo button and a corresponding keyboard shortcut—Ctrl+Z. Unlike Word, however, which stores an unlimited number of changes, Excel can undo only the 16 most recent actions. When the Undo buffer is full, the oldest entry in the list vanishes to make room for your most recent formatting change, move, copy, data entry, or other action. If you search the Internet, you will find references to a simple change in the Registry that can expand the Undo buffer significantly; however, that Registry hack no longer works in Excel 2002 or Excel 2003.

Excel's Undo feature has other significant limitations. For example, the Undo buffer is disabled for performance reasons whenever you run a macro. If you delete rows from a list and then remove outlining, you cannot undo any changes. Likewise, adding a chart or other object to a sheet clears the Undo history completely. You have absolutely no warning before Excel clears the Undo buffer, and you cannot recover its contents afterwards.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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