#Edit undo on mac how to#

You can undo all or part of the most recent undo by selecting from the drop-down menu next to the Redo command. If you undo 20 actions, however, those 20 actions will be listed in reverse order in the Redo menu. The Redo command (Ctrl+Y or Shift+Alt+Backspace in Windows Cmd+Y on a Mac) is mostly grayed out in the Quick Access Toolbar. But what if I went back too far? How can I undo the Undo?вЂќ I open the Undo menu, go back about 20 steps, and undo to that point. вЂњLetвЂ™s say that I know I made a mistake roughly 20 steps ago.

#Edit undo on mac how to#

I always mention the Undo drop-down menu, but recently someone asked how to actually use it. Opening that menu will give you a list of up to the last 100 operations that you have done in Excel. If you look closely at the Undo icon in the Quick Access Toolbar, youвЂ™ll see a drop-down menu next to the icon. That icon, along with its associated drop-down menu, is the key to undoing back to a certain point in time. In fact, the second most-popular answer is from people who donвЂ™t know Ctrl+Z but make a curved motion with their hand, indicating the Undo icon in the Quick Access Toolbar. Only once has anyone mentioned Alt+Backspace, so Ctrl+Z/Cmd+Z is clearly the norm. Almost universally, the answer is Ctrl+Z. When IвЂ™m performing one of my live Power Excel seminars, I always ask attendees about the shortcut they use for Undo. Today, you can undo with Ctrl+Z or Alt+Backspace in Windows or Cmd+Z on a Mac. Later, Windows 3.1 introduced Alt+Backspace as the shortcut for Undo. When Excel was released for Apple computers in 1985, it used Cmd+Z for Undo. Xerox debuted the Ctrl+Z shortcut for Undo in 1974. But how do you actually go back to a certain point in time?

Today, Excel offers an Undo stack that will let you undo the previous 100 operations. When Undo first appeared in Excel, you could only undo the most recent operation.