#DROPDOWN IN EXCEL FOR MAC HOW TO#

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.

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.

#DROPDOWN IN EXCEL FOR MAC HOW TO#

Dropdown in excel for mac