Quick access toolbar pada excel 2007
On the right, Excel shows all the buttons currently on the Quick Access toolbar in the order they appear on the toolbar.
Excel 2007 For Dummies, you can assign a macro created in Excel 2007 to a custom button on the Quick Access toolbar and then run it by clicking that button.
Use the Customize settings to add any Excel 2007 command to the Quick Access toolbar.Add non-Ribbon commands to the Quick Access toolbar.2Click the Customize tab.Use the Move Up and Move Down buttons to reposition the newly added command button.The resulting drop-down menu contains the following commands: New, Open, E-mail, Quick Print, Print Preview, Spelling, Sort Ascending, and Sort Descending.Excel 2007 For Dummies, the Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use often.To quickly remove a button from the Quick Access toolbar, right-click it and then select Remove from Quick Access Toolbar on the shortcut menu.You can use the *.exportedUI file to create the same customizations on another computer by importing the file.Click the Add button.Add buttons to the Quick Access toolbar.Excel lists the names of all macros created in the current workbook and those saved in the personal.
You can reset the Quick Access toolbar to its original configuration by clicking the Reset button on the Customize tab of the Excel Options dialog box.
3Click Macros in the Choose Commands From drop-down list box.
4Select the name of the macro and click the Add button.6Select an icon to use for the button.By default, the Quick Access toolbar contains only the Save, Undo, and Redo commands.7Click OK dragon ball af episodes english two times.To add any of these commands to the toolbar, simply click the option on the drop-down menu.For example, if you want to display only the commands that do not appear on the Ribbon, select Commands Not in the Ribbon.Click the command you want to add to the Quick Access toolbar in the list on the left.To add a non-Ribbon command to the Quick Access toolbar, follow these steps: Click the Customize Quick Access Toolbar button and then click the More Commands option near the bottom of the drop-down menu.The command button appears at the bottom of the list on the right.This provides quicker access to a macro than using the Macro dialog box.The Modify Button dialog box appears.The macro appears in the list box on the right side of the dialog box.To export Ribbon or Quick Access Toolbar customizations: On the File tab, click Options, click Customize Ribbon or Quick Access.