Click on the small options icon to the right of the quick access toolbar. Activate the document location quick access tool. Select the macro you want to add to the Quick Access Toolbar and click Add and then OK. Open the Customize dialog box using one of these methods: Right-click a command on the ribbon and choose Customize Quick Access Toolbar. Step 1: Activate the document location tool.In the Excel Options dialog box on the Quick Access Toolbar tab, from the Choose commands from drop-down list, select Macros. In order to add/remove an icon to/from Quick Access Toolbar, you need to right click on the icon, then you will see Add to Quick Access Toolbar or Remove.Ribbon - Where you can access the tools for formatting your. open, save, print, protect document, etc.). File Tab (Backstage View) - The backstage view is where you manage your files and the information about them (e.g. Quick Access Toolbar - Keep shortcuts to your favorite tools.
Click the Customize Quick Access Toolbar drop-down arrow. /rebates/2ftutorial2fmicrosoft-excel-2016-excel-from-beginner-to-advanced2fquick-access-toolbar2f&. Excel 2016 for Windows - Quick Start Guide The Interface 1.This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016. To add a macro to the Quick Access Toolbar, follow these steps. How to Add a Macro to the Quick Access Toolbar in Microsoft Excel See Microsoft Excel: Tips and Tricks for similar articles.Ĭreating a macro and adding it to the Quick Access Toolbar makes it easier to complete a set of operations that you perform regularly.
0 kommentar(er)
