Datasheet
Separate the Excel Toolbars
1. Choose View➪Toolbars➪ Customize. The Customize
dialog box appears.
2. Click the Options tab (see Figure 1-9).
3. Select the Show Standard and Formatting Toolbars on Two
Rows option. Excel displays the toolbars separately, which
makes the most commonly used tools easily accessible.
4. Click the Close button.
In the Customize dialog box, select the Always Show Full Menus to
immediately display all the menu choices when you click a menu
such as File or View. With this option unchecked, you must click the
down arrow on a menu to display the remainder of the options.
Display Different Toolbars
1. Choose View➪Toolbars. Toolbars currently displayed
have a check mark next to them. (See Figure 1-10.)
2. Select a toolbar you want to display. A few of the tool-
bars are
• Standard: See Chapters 1, 7, 9, 10, and 12.
• Formatting: See Chapters 4, 5, and 8.
• Drawing: See Chapters 5 and 9
• Chart: See Chapter 9
• Picture: See Chapter 5
3. Repeat Steps 1 and 2 to hide a toolbar from display.
Figure 1-9: Display the Standard and Formatting
toolbars in their entirety
Figure 1-10: The selection of Excel toolbars
➟
10
Chapter 1: Working with Excel Files
05_574884 ch01.qxp 3/7/06 9:57 PM Page 10