With the advent of Office 2007, Microsoft introduced the Quick Access Toolbar. Located on the top line of the Window, above any other toolbars, the Quick Access Toolbar initially has very minimal functionality. But, it can easily be customized by you to add your favorite functions within that program.
The Quick Access Toolbar is different in Excel, Outlook, Word, PowerPoint, etc. That is, each has its own Quick Access Toolbar that can be configured independently. You don’t have to make any changes to it, but changes in one program are independent of the Quick Access Toolbars in the other Office programs.
Initially, the Excel Quick Access Toolbar looks like this (the others are similar at this stage, too). The arrow points to the configuration button that opens the Customize Quick Access Toolbar option list.
The Quick Access Toolbar’s configuration button allows easy addition of a few choices, simply by clicking to select the item. For example, to add Open Recent File to the Quick Access Toolbar, just click on Open Recent File in the popup options menu.
As you can see in the image below, having selected Open Recent File in the options menu, it has now been added to the Quick Access Toolbar.
Any icon that is on the Ribbon can similarly be added to the Quick Access Toolbar. All you have to do is to right-click on that icon and then select "Add to Quick Access Toolbar."
The most extensive way to add items to the Quick Access Toolbar is via one of the options available by selecting More Commands on the Customize Quick Access Toolbar option list.
You can access the same functions directly via the Options button on the File menu. Then, you select Quick Access Toolbar.
Note that, via the Options configuration, by default the choices are from a subset called "Popular Commands." You can access many more functions by changing Popular Commands to All Commands. You can even select "Commands Not in the Ribbon."
By configuring the Quick Access Toolbar, you can make those commands that You use frequently, accessible when they’re not currently displayed on the Ribbon.
Modifying the Quick Access Toolbar is one of first things I do after installing Microsoft Office — if nothing else, I want to have a Save As icon and a Print icon available.