Write function keys into your macros. (function key macros speed pointer movement, format cells, erase ranges, retrieve files) (Macro Basics) (column)

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 …