Microsoft Office Tutorials and References
In Depth Information
Excel starts recording
every keystroke and
command.
You can record any
set of keystrokes. This
example creates a
money format.
8
8
Click the Number
Group launcher.
9
0
!
9
Click a formatting
category.
0
Type the number of
decimal places.
!
Click here and select a
symbol.
@
@
Click OK.
#
Click Stop Recording.
You can now apply the macro anywhere
in the workbook by selecting the cells you
want to format and typing the keyboard
shortcut you chose in Step 4.
#
Did You Know?
By default, you can find the Macro Recording button
on the status bar. You decide what options display on
the status bar by right-clicking the bar and displaying
the Customize Status Bar menu. When working with
macros, make sure you select Macro Recording and
Macro Playback from the menu.
Did You Know?
Macros are limited in the kinds of tasks they automate.
If you have programming experience or aptitude, you
can edit and enormously extend Excel macros by using
the Visual Basic Editor, available by pressing Alt+F11.
Chapter 10: Customize Excel
231
Search JabSto ::




Custom Search