How to Modify Microsoft Excel

Microsoft Excel 2007
1. Modify Excel 2007 by changing the Quick Access toolbar, Themes and Styles to meet individual needs. Right-click on the three default buttons (\'Save,\' \'Undo\' and \'Redo\'), and select \'Customize.\' A two-pane window will open.
2. Select commands for the Quick Access toolbar. The left pane accesses all available Excel commands; the right pane shows the existing three buttons. Highlight a command and press the \'Add\' button to move the command to the Quick Access pane. Controls are available to move commands up and down, add the separator bar creates a group and organizes commands to meet individual needs. Only one row is possible. When finished, click \'OK.\'
3. Modify the Quick Access Gallery. From the Home Tab, the Quick Access Gallery shows a number of default styles of font weight, size, color and backgrounds. Customize styles by right-clicking on any style and selecting \'Modify.\'
4. Locate and modify Themes on the Page Layout tab. Customizing Themes adds significant flexibility for spreadsheet design in terms of colors, fonts and styles. Colors, Fonts and Effects can be individually modified, then three modified features are saved as a group in a Theme for easy future access.
5. Select the \'Fonts\' button. A window appears with font selection boxes for \'Heading\' and \'Body.\' Select the desired font pair, add a name for the pair and click \'Save.\' In the future, when the Font button is clicked, this pair will show in the \'Custom\' grouping. Creating a font pair automatically changes all of the default styles in the Quick Access Gallery to the theme's body and heading fonts.
6. Modify theme colors by pressing the \'Colors\' button and choosing \'Create new Theme colors\' from the very bottom of the drop-down menu. A window will open, showing the current theme colors for different aspects of the spreadsheet. Colors can be selected from drop-down menus. Two interactive graphics will show the results of the colors selected. The color grouping can be named and saved for future use.
7. Select an effect to be the default with the new colors and fonts. Then press the \'Theme\' button and select \'Save current Theme\' at the bottom of the drop-down window. Give it a name; it will appear in the Custom grouping in the future. Changing the spreadsheet Effects is not possible as part of the Themes. Graphic features can be modified individually when used in the spreadsheet.
Excel 2010
8. Right-click on the Ribbon and select \'Customize the Ribbon.\' Here you can select commands, place them in a new or existing Group, then add them to existing or new Tabs.
9. Use the same instructions from Section 1, Step 2 to modify the Quick Access toolbar. Select commands for the toolbar to speed program usage. When you are finished with the Ribbon and Quick Access toolbar, there will be a command to \'Import\' or \'Export\' both the Ribbon customization and the Quick Access toolbar customization. \'Export\' creates a back-up copy to be placed in a folder that is somewhere other than \'\\Programs\\Microsoft\\Office.\' This ensures that the back-up does not get erased if Office needs to be reinstalled.
10. Restore a lost Ribbon or Quick Access toolbars by importing them from the Customize screen. Both the Ribbon and toolbar modifications are saved in the same export file.