Quick Access Tool Bar In Excell 2013 For Mac

  1. Quick Access Toolbar In Excel 2013 For Mac Free Download
  2. Quick Access Tool Bar In Excell 2013 For Mac Catalina
  3. Quick Access Toolbar In Excel 2013 For Mac Shortcut

Home > Articles > Home & Office Computing > Microsoft Applications

Quick Access Toolbar in Excel 2013. Quick Access Toolbar is Located just above the Ribbon. It let you access the most general & common commands. By default, Quick Access Toolbar in Excel 2013 includes Commands like, Save, Undo, and Repeat. Yes of Course you can add other commands to Quick Access Toolbar depending on your preference. USA.com provides easy to find states, metro areas, counties, cities, zip codes, and area codes information, including population, races, income, housing, school.

  1. Using the Quick Access Toolbar
< BackPage 2 of 11Next >
This chapter is from the book
Excel 2013 In Depth

This chapter is from the book

This chapter is from the book

Using the Quick Access Toolbar

A problem with the ribbon is that only one-seventh of the commands are visible at any given time. You will find yourself moving from one tab to another. The alternative is to use the Quick Access Toolbar (QAT) to store your favorite commands.

The QAT starts out as a tiny toolbar with Save, Undo, and Redo. It is initially located above the File tab in the ribbon.

If you start using the QAT frequently, you can right-click the toolbar and choose Show Quick Access Toolbar Below the Ribbon.

Adding Icons to the QAT

The drop-down at the right side of the QAT, shown on the right side in Figure 3.22, offers 12 popular commands you might choose to add to the Quick Access Toolbar. Choose a command from this list to add it to the QAT.

Figure 3.22. Use the drop-down at the right side of the QAT to add 12 popular commands.

Note that changes to the QAT made in Excel 2010 also appear in Excel 2013, and vice versa. The Open Recent File icon is no longer available in Excel 2013, but if you add it to the QAT in Excel 2010, it appears in Excel 2013. Unfortunately, the icon simply goes to the File, Open pane.

When you find a command in the ribbon you are likely to use often, you can easily add the command to the QAT. To do so, right-click any command in the ribbon and select Add to Quick Access Toolbar. Items added to the Quick Access Toolbar using the right-click method are added to the right side of the QAT.

Quick Access Toolbar In Excel 2013 For Mac Free Download

The right-click method works for many commands, but not with individual items within commands. For example, you can put the Font Size drop-down on the QAT, but you cannot specifically put size 16 font in the QAT.

Removing Commands from the QAT

You can remove an icon from the QAT by right-clicking the icon and selecting Remove from Quick Access Toolbar.

Customizing the QAT

You can make minor changes to the QAT by using the context menus, but you can have far more control over the QAT if you use the Customize command. Right-click the QAT and select Customize Quick Access Toolbar to display the Quick Access Toolbar section of the Excel Options dialog, as shown in Figure 3.23.

Figure 3.23. You can customize the QAT using the Excel Options dialog.

The Excel Options dialog offers many features for customizing the Quick Access Toolbar:

  • You can choose to customize the QAT for all documents on your computer or just for the current workbook by using the top-right drop-down menu.
  • You can add separators between icons to group the icons logically. A separator icon is available at the top of the left menu. Click the separator icon in the left list box and then click the Add>> icon in the center of the screen.
  • You can resequence the order of the icons on the toolbar. Select an icon in the right list box and then click the up/down arrow icons on the right side of the dialog.
  • You can access 2,000+ commands, including the commands from every tab and commands that are not available in the ribbon. Although the dialog starts with just 53 popular commands in the left list box, use the left drop-down to choose All Command or Commands Not in the Ribbon. When you find a command in the left list box, select the command and then click Add>> in the center of the dialog to add that command to the QAT.
  • You can reset the QAT to its original default state using the Reset button in the lower right.
  • You can export your custom QAT icons from your computer and import on another computer.
  • You can move the QAT to appear above or below the ribbon using the check box in the lower right.

Assigning VBA Macros to Quick Access Toolbar Buttons

Typically, a VBA macro is assigned to a shortcut key. In legacy versions of Excel, it was easy to customize the menu system to add commands to invoke macros. Excel 2013 offers a weak interface for adding custom macros to the QAT. In the Excel Options dialog is a drop-down called Macros. If you select this group, you see all public macros in all open workbooks. You can select a macro and click Add to add that macro to the QAT.

Initially, every macro added to the Quick Access Toolbar gets an identical flowchart icon. However, you can select an icon in the Customize Quick Access Toolbar list box and click the Modify button. The Modify Button dialog that appears enables you to choose from 55 available icons for a macro as shown in Figure 3.24. Most of these buttons are similar to icons that are already popular. For example, the Print icon is fairly well known and has a meaning. In addition to choosing from the 55 icons, you can type any text for a display name. The display name does not appear next to the button. However, if you hover your mouse over the icon on the QAT, you can see the display name in a tooltip.

Figure 3.24. For macros, you can customize the button image and add a display name on the QAT.

Related Resources

  • Online Video $239.99
  • Book $19.99
  • Book $19.99

How to switch between multiple workbooks?

In our daily work, we may work with multiple workbooks, to toggle between two workbooks may be easy for us, but, if there are multiple opened workbooks needed to be switched between from time to time, how could you switch between these multiple opened workbooks?


Switch between multiple opened workbooks with kutools for Excel

Switch between multiple opened workbooks with Office Tab Philip glass einstein on the beach.

Switch between multiple opened workbooks with Switch Windows command

There is a command called Switch Windows in Excel, by using it, you can quickly switch between multiple workbooks.

In one of your opened workbook, click View > Switch Windows, and then from the Switch Windows drop down list, choose the workbook that you want to switch. See screenshot:

Switch between multiple opened workbooks with Quick Access Toolbar

With the above method, you need to toggle the tabs time and time again when you do other operations, here, I can help you to add the Switch Windows command to the Customize Quick Access Toolbar, and this will cut down your clicks. Please do as follows:

1. In the opened workbook, click the Customize Quick Access Toolbar in the Excel window, and then choose More Commands from the menu, see screenshot:

2. In the Excel Options dialog box, click Quick Access Toolbar from the left pane. Then select All Commands from the drop-down list under Choose commands from, scroll down and select Switch Windows, then click the Add>> button to move that command to the right-hand window. See screenshot:

3. Then click OK button, and you can see the Switch Windows command has been displayed in the Quick Access Toolbar, and you can switch between the workbooks easily with one click.

Switch between multiple opened workbooks with shortcut keys

If you like to use the keyboards, here also have shortcut keys for you to quickly toggle between multiple workbooks.

Holding the Ctrl + Tab keys together can help you move from one window to the next window, if you have only two windows, this method will be faster. However, with more than two opened workbooks, this method doesn’t work very well because it will cycle through each opened workbook.

Switch between multiple opened workbooks with kutools for Excel

If you have Kutools for Excel, with its Navigation utility, you can quickly switch between multiple workbooks and worksheets.

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

After installing Kutools for Excel, please do as following steps:

1. Click Kutools > Navigation, see screenshot:

2. In the Navigation pane, click Workbook & Sheet icon, and you can see all the opened workbooks are listed into the list box, you can switch between them quickly and conveniently.

Note: In the Navigation pane, you can also sort the opened workbooks in ascending or descending order with the and icons.

Quick Access Tool Bar In Excell 2013 For Mac Catalina

Switch between multiple opened workbooks with Office Tab

If you have installed Office Tab in your computer, it helps you view and edit multiple files within a single tabbed window, to know more about Office Tab Office Tab and download it (free trial in 30 days).

After installed Office Tab, and open multiple workbooks, you will see all the workbook names have been displayed within a single tabbed window as following screenshot shown, and then you can quickly switch among them by a click.

Demo: Switch between multiple opened workbooks

Kutools for Excel and Office Tab are useful tools for most Microsoft users. Click to free trial them !

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range..
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.

Quick Access Toolbar In Excel 2013 For Mac Shortcut

Loading comment.. The comment will be refreshed after 00:00.