AccessMyLibrary provides FREE access to millions of articles from top publications available through your library.
WRITE FUNCTION KEYS INTO YOUR MACROS
It's hard to imagine working in a spreadsheet without the use of function keys. Some of these keys provide shortcuts to procedures available via the menus, while other keys let you perform tasks you cannot do any other way.
The function keys are even more potent when you incorporate them in your macros.
WHAT IS A MACRO?
A macro is a collection of instructions stored as labels in the worksheet. These instructions automate procedures you'd normally perform manually. Try one out:
In an empty worksheet, enter the label My Name in cell B1. In cell A1, enter '\n. Now, assign the macro a name, which usually consists of a backslash …