[ Pobierz całość w formacie PDF ]
.f03ie08Figure 3-8.Use the Begin A Group command on the Modify Selection menu to add orremove lines.71Chapter 3Part 1: Examining the Excel EnvironmentMicrosoft Office Excel 2003 Inside OutYou control the display of button faces by using commands on the Modify Selection menushown in Figure 3-8.The Default Style command, the two Text Only commands, and theImage And Text command on the Modify Selection menu control the display of buttons.Ontoolbars, you can choose to show command names, button images, or both.If you choose theText Only (In Menus) command, the button face disappears when the selected command ison a menu.If you then drag the command from a menu to a toolbar, the button face appearsand the text disappears.If you choose the Text Only (Always) command, the button face doesnot appear in either location.The Image And Text command causes both the button face andthe command text to appear in any location.The Default Style command restores the com-mand to its normal appearance, which for most commands is image and text in menus, andimage only on toolbars.Giving Face to the FacelessIf a menu command does not have an associated button face, you can assign an existing but-ton face or create one from scratch.With the Customize dialog box open, simply select thefaceless command, click the Modify Selection button, and then click either Change ButtonImage or Edit Button Image.In Figure 3-9, we added a happy face to the previously facelessConditional Formatting command.f03ie09Figure 3-9.Add a face to a faceless command, or change an existing face.72Chapter 3Part 1: Examining the Excel EnvironmentCustom-Tailoring the Excel WorkspaceYou can also copy faces from other buttons (not necessarily the best idea, but it s possible),modify existing faces, and create brand-new button faces from scratch.Rearranging Menus and SubmenusYou can customize your menus by using the same techniques employed when customizingtoolbars and commands.An additional technique for customizing menus is to use Built-InMenus.Built-In Menus is a category on the Commands tab of the Customize dialog box thatcontains all the predefined menus and submenus available in Excel.As with any command orbutton, you can place items from the Built-In Menus list on any toolbar, menu, or menu bar.For example, you can drag the Toolbars menu from the Built-In Menus list to the menu barto create a separate menu for toolbars, as shown in Figure 3-10.The Toolbars menu isnormally a submenu of the View menu, so you could then drag Toolbars from the Viewmenu to remove it.Using the Customize dialog box, you can drag entire menus to other menus, transformingthem into submenus.For example, you could drag the Help menu to the bottom of the Viewmenu to transform the Help menu into a submenu.You can even add menus to toolbars andadd toolbar buttons to menu bars.f03ie10Figure 3-10.You can rearrange Built-In Menus to make frequently used commands moreaccessible.73Chapter 3Part 1: Examining the Excel EnvironmentMicrosoft Office Excel 2003 Inside OutSpreadsheet Assistant"! Buttons and CommandsOn the companion CD you will find a demo version of an add-in called the SpreadsheetAssistant, which provides dozens of useful, time-saving features, including a new menu anda new toolbar, both of which are shown below.The Spreadsheet Assistant also adds a num-ber of additional commands to existing menus.G03ie01To install the Spreadsheet Assistant, refer to the StartCD page on the companion CD andfollow the instructions on your screen.Changing the Face of ButtonsThere are several ways you can work with button faces.All of these methods start by display-ing the Customize dialog box:Ï% Change a button face using the Change Button Image command.Ï% Change a button face using the Edit Button Image command.Ï% Create your own button face from scratch.Ï% Copy an existing button face.Using the Customize dialog box, right-click on any toolbar button to display the shortcutmenu.(Yes, this is the same as the Modify Selection menu.) As shown in Figure 3-9, theChange Button Image command displays a palette of faces that have not been used on any ofExcel s built-in buttons.74Chapter 3Part 1: Examining the Excel EnvironmentCustom-Tailoring the Excel WorkspaceIf the selections on the Change Button Image palette don t float your boat, you can performplastic surgery by selecting the Edit Button Image command, which displays the ButtonEditor, shown in Figure 3-11.f03ie11Figure 3-11.You can use the Button Editor to change the face of any toolbar button.Note If you want to create a button face where none currently exists, you ll first need toselect the command to which you want to add a face.If the command isn t already on amenu or toolbar, you ll need to add it first.How to Use the Button EditorThe small squares in the Picture section of the Button Editor dialog box correspond to pixels,which are the units of resolution on your computer screen.To erase some of the existingpixels, click the Erase square in the Colors area, and then click or drag through any pixels inthe Picture area that you want to remove [ Pobierz caÅ‚ość w formacie PDF ]