Pages

Tuesday, December 13, 2011

Easily undo multiple actions in Excel (2000/2003/2007)

If you're a longtime keyboard jockey, you probably instinctively use the [Ctrl]Z shortcut when you want to undo a change you've made. However, if you need to backtrack through many steps, you may not recall exactly how many steps you need to undo. Chances are you'll backtrack too far and then wind up redoing more steps than you had planned. The next time you find yourself in this situation, use the dropdown arrows on Excel's Undo and Redo buttons. These provide you with a running list of your recent actions so you can easily undo or repeat exactly the steps you want. (In Excel 2007, the Undo and Redo buttons still have a dropdown arrow. But you'll need to look for these buttons on your Quick Access Toolbar.)

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.