Excel 2010 Bible
A number of Excel features can probably be fairly called “advanced” features if for no better reason than the ways in which they ...
29_474877-pp04.indd 54029_474877-pp04.indd 540 3/29/10 11:44 PM3/29/10 11:44 PM ...
541 CHAPTER Customizing the Excel User Interface IN THIS CHAPTER About the Quick Access toolbar Adding frequently used commands ...
Part IV: Using Advanced Excel Features 542 About the Quick Access toolbar By default, the Quick Access toolbar is located on the ...
Chapter 23: Customizing the Excel User Interface 543 Adding new commands to the Quick Access toolbar You can add a new command t ...
Part IV: Using Advanced Excel Features 544 FIGURE 23.3 Use the Quick Access Toolbar tab in the Excel Options dialog box to custo ...
Chapter 23: Customizing the Excel User Interface 545 Sometimes, you need to do some guessing to find a particular command. For e ...
Part IV: Using Advanced Excel Features 546 Customizing the Ribbon The Ribbon is Excel’s primary user interface. It consists of t ...
Chapter 23: Customizing the Excel User Interface 547 l (^) Add a new group to tab. l Change the order of the tabs. l (^) Change ...
Part IV: Using Advanced Excel Features 548 FIGURE 23.4 The Customize Ribbon tab of the Excel Options dialog box. Customizing the ...
Chapter 23: Customizing the Excel User Interface 549 Use the New Tab button to create a new tab, and the New Group button to cre ...
...
551 CHAPTER Using Custom Number Formats IN THIS CHAPTER An overview of custom number formatting How to create a custom number fo ...
Part IV: Using Advanced Excel Features 552 One more thing to keep in mind: If you use the Find and Replace dialog box (Home ➪ Ed ...
Chapter 24: Using Custom Number Formats 553 Note Some of these buttons actually apply predefined styles to the selected cells. A ...
Part IV: Using Advanced Excel Features 554 Using the Format Cells dialog box to format numbers For maximum control of number for ...
Chapter 24: Using Custom Number Formats 555 Note If the cell displays a series of hash marks after you apply a number format (su ...
Part IV: Using Advanced Excel Features 556 You construct a number format by specifying a series of codes as a number format stri ...
Chapter 24: Using Custom Number Formats 557 FIGURE 24.2 Examples of custom number formatting. Parts of a number format string A ...
Part IV: Using Advanced Excel Features 558 The following is an example of a custom number format that specifies a different form ...
«
25
26
27
28
29
30
31
32
33
34
»
Free download pdf