Adding the Repeat command icon to the Quick Access Toolbar in Excel for Windows is a simple process that I explained in a blog post last week. Excel for Mac — 2011 or 2008 — doesn’t have a Quick Access Toolbar, but you can customize the toolbars and menus.
Add the Repeat Icon to the Standard Toolbar
- Right-click the toolbar and select Customize Toolbars and Menus…
- At the top of the dialog box select Toolbars and Menus
- Select the Show checkbox for the Worksheet Menu Bar
- In the Worksheet Menu Bar click Edit
- Select Repeat and while holding down the Control key, drag to the Standard Toolbar
- Click OK
Strangely enough, if you select Commands at the top of the Customize Toolbars and Menus dialog box, then select Edit from the Categories window, there is no Repeat command in the commands window. This is why I thought it didn’t exist in Excel for Mac.
The Three Different States of the Repeat Icon
The Repeat icon becomes active and has color when the current command can be repeated. It will be grayed-out if the current command can’t be repeated. After there’s been an Undo action, the Repeat icon will change to a Redo icon.
Turn on Toolbar ScreenTips
There’s an option to show shortcut keys in the toolbar screen tips that’s nice to have turned on. It shows the keyboard shortcut for the Repeat command to be Cmd+6.
- Right click the Standard Toolbar
- Select Customize Toolbars and Menus…
- Click the Show shortcut keys in ScreenTip checkbox
- Click OK