Page 123 - Excel Timesaving Techniques for Dummies

23_574272 ch20.qxd 10/1/04 10:43 PM Page 108
108
Technique 20: Customizing Number Formats
1. Create the custom number format that hides all
types of entries. To do so, open the Number tab
of the Format Cells dialog box, select Custom in
the Category list box, enter ;;; in the Type text
box, and click OK. (See Figure 20-4.)

• Figure 20-5: Assigning the custom number format to a
new style called All Hidden.

• Figure 20-4: Creating the custom number format that
hides all types of cell entries.
• Figure 20-6: Recording a keystroke macro All_hidden
2. Assign the new custom format to a new style by that selects the All Hidden style.
choosing Format➪Style, entering All Hidden
in the Style Name text box, and clicking OK. 5. Choose View➪Toolbars➪Customize to open the
(See Figure 20-5.)
Customize dialog box. If the toolbar to which
3. Begin recording a keystroke macro that selects you want to add the custom button isn’t
this new All Hidden style. To do so, choose already visible, click the Toolbars tab and
Tools➪Macro➪Record New Macro, enter select this toolbar’s check box.
All_hidden in the Macro Name text box, select 6. Click the Commands tab, select the Macros in
Personal Macro Workbook in the Store Macro
Categories list box, and then drag the custom
In drop-down list box, and click OK. (See
button from the Customize dialog box to the
Figure 20-6.)
desired position on the toolbar, as shown in
4. To finish recording the macro, choose Figure 20-7.
Format➪Style, select All Hidden in the Style 7. Assign the keystroke macro to the custom but-
Name drop-down list box, click OK, and then
ton by right-clicking on the button and then
click the Stop button in the Stop Recording
selecting Assign Macro on its shortcut menu.
toolbar.