Macros are simple programs which can automate tasks which are required frequently. Macros can be recorded or written using the Macro Command Language.

Recording Macros

First, go to a cell on your spreadsheet to record your macro commands to. This can be the first cell of a new page of your spreadsheet, or a cell below the data, but in any case, it should allow enough room to record several commands without overwriting any data.

Under the Tools menu, the submenu Macro has an option to Record. You are then prompted to confirm the cell to contain the first of these recorded commands.

Note:

The keystrokes and menu options you use should be the quickest possible way to perform the task in question.

When the keystrokes have been recorded satisfactorily, select Stop Record from the Tools, Macro submenu. Your Macro should then be finished with a {RETURN} command.

If you wish to learn more about recording macros, or typing your own macros with the Macro Command Language, see the on-line help.

Naming your Macro - Shortcut Keys

If you name the block where the macro starts "\F" for example, then the macro can be run by the keyboard keys [Ctrl]+[F].

Next Page > > >