excel 2016 quick access toolbar make smaller

Then select the Commands Not in the Ribbon option. To get to these, click the little arrow at the edge of the QAT and select More Commands. Interestingly (if you like that sort of thing!), there is a list if commands that are not available on the ribbon.

Add a Command to the Quick Access ToolbarĪdding a command that already exists in the Ribbon is as easy as right-clicking on it and selecting Add to Quick Access Toolbar. You most likely already know what the toolbar is, but if a cursory glance over the shoulders of most of my colleagues tells me anything, you are probably not using it. This is where the Quick Access Toolbar comes in.

In future we will hopefully have dynamic UIs that will reshape themselves around a mix of what we are currently doing, and what we frequently do, we are not there yet though (stupid always ‘in the future’ future!). The reality of a feature-rich application like Word or PowerPoint is that 20% of the commands are the ones you use 80% of the time, and possibly 10% of the commands 90% of the time however, the user interface gives most of the options equal billing. You can often find yourself suddenly overwhelmed by the multitude of options in the visual array and forget why you are looking at it! Imagine trying to make people go back to the below today! I had a friend who was an Office trainer who totally hated it. The Ribbon was introduced in Office 2007 to much weeping and gnashing of teeth – it is hard to believe that people preferred to search for commands in menus and submenus. The Quick Access Toolbar (QAT) is that little ribbon generally found over the ribbon to which you can add your own commands. Joking aside, the idea is that if you are a project manager or a team member, these tips will save you time and enable you to do more. In this series of blog posts, I will share some of my wisdom with you – lucky you! I live in Microsoft Office, in particular, Work, Excel, and Outlook. I’m one of these annoying PC users who know and use tons of keyboard and productivity shortcuts.

Excel 2016 quick access toolbar make smaller