➤ Change the order of the groups within a tab. You can customize the Ribbon in these ways: HomeTab: Displays all commands that are available when the Home tab is FileTab: Displays the commands available in the back stage window. Macros: Displays a list of all available macros. All Commands: Displays a complete list of Excel commands. Commands Not in the Ribbon: Displays a list of commands that you cannot Popular Commands: Displays commands that Excel users commonly use. Some of the items in the drop-down list are described here:.SELECT AN ITEM FROM THE DROP-DOWN LIST, AND THE LIST DISPLAYS ONLY THE COMMANDS FOR THAT ITEM. ABOVE THE COMMAND LIST ON THE LEFT IS A DROP-DOWN CONTROL THAT RIGHT SIDE SHOWS THE COMMANDS THAT ARE NOW ON THE QUICK ACCESS TOOLBAR. THE LEFT SIDE OF THE DIALOG BOX DISPLAYS A LIST OF EXCEL COMMANDS, AND THE SHOWS THE QUICK ACCESS TOOLBAR TAB OF THE EXCEL OPTIONS DIALOG BOX.THE QUICKACCESSTOOLBAR DROP-DOWN MENU IS ONEWAYTO ADDA NEW.This dialog box is to right-click any Quick Access toolbar or Ribbon control and choose Use the Quick AccessToolbar tab of the Excel Options dialog box.A quick way to access Is added to your Quick Access toolbar, positioned after the last control. Right-click any control on the Ribbon and chooseAdd to Quick AccessToolbar.The control Click the Quick Access toolbar drop-down control, which displays a down-pointing arrowĪnd is located on the right side of the Quick Access toolbar. You can add a new command to the Quick Access toolbar in three ways: Redo: Reverses the effect of the last undo Undo: Reverses the effect of the last action. By default, the Quick Access toolbar is located on the left side of the Excel title bar, and it After youĬustomize the Quick Access toolbar, your frequently used commands will always be one If you find that you continually need to switch Ribbon tabs because a frequently usedĬommand never seems to be on the Ribbon that’s displayed, this tip is for you.The QuickĪccess toolbar is always visible, regardless of which Ribbon tab is selected. Status bar, repeat those instructions, but specifyTrue in the statement The status bar will be removed from all open workbook windows.To redisplay the Press Ctrl+G to display the Immediate window. Press Alt+F11 to display theVisual Basic Editor. You can also hide the status bar, at the bottom of the Excel window. Options dialog box (choose File➜Options). To hide other elements, you must make a trip to the Advanced tab of the Excel Zoom group:These commands enable you to zoom the worksheet in or out.Īnother way to zoom is to use the Zoom slider on the status bar. (relevant only in Page Layout view), the Formula bar, worksheet gridlines, and row Show group:The four checkboxes in this group control the visibility of the Ruler Page Break Preview also shows page breaks, but theĭisplay isn’t nearly as nice.The status bar has icons for each of these views.ĬustomViews enable you to create named views of worksheet settings (forĮxample, a view in which certain columns are hidden). Page Layout view is useful if you require precise control over how WorkbookViews group:These options control the overall view. Tab and use the OfficeTheme drop-down list: Options to display the Excel Options dialog box. The names of the Excel worksheet functions appear in all uppercase letters: forĮxample, “Use the SUM function to add the values in column A.”
=VLOOKUP(StockNumber,PriceList,2,False) Clear the Show Insert Options Buttons check box. Formulas usually appear on a separate line in monospace font.The Advanced options of the Excel Options dialog box. Scroll through the available options until you see the section named Cut, Copy, and Paste.At the left of the dialog box click Advanced.In Excel 2010 and later versions, display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. If you find the Insert Options button distracting, or if you never use it, you may want to turn it off. Click the button, and Excel displays some options about how the inserted row, column, or cell should be formatted. The button, called "Insert Options," has a small paintbrush on it, similar to the Format Painter tool. When you insert any of these, Excel displays a small, floating "button" right near the inserted row, column, or cell. Excel includes a feature that allows you to modify how you insert rows, columns, or cells in your worksheet.
0 kommentar(er)
