Page 218 - IT 402 v2.0 class 10
P. 218
MACRO
Macros are the set of stored functions that can be used to automate processes that are repeated often. They
are tools which can be used to perform most of the redundant tasks with relative ease. A Macro is a saved
sequence of commands or keystrokes that are stored for later use. An example of a simple macro is one that
types our address. he OpenO ce macro language is very flexible allowing automation of both simple and
complex tasks. Macros are especially useful in execution of such type of tasks which are repeated again and
again fre uently or within a specified time interval in the same manner.
What are the Advantages of Macro?
Some of the advantages of macro are as follows:
It saves user’s time.
It allows to repeat a number of commands in just one click or using the shortcut key.
It allows a user to record numerous formatting commands or formulas in a single worksheet.
It allows a user to use their names for each macro.
It reduces the errors occurring with repetitive tasks.
It is capable to perform any kind of complex calculations easily.
Using the Macro Recorder
The following steps to create a macro that performs paste special with 'Paste Special' with 'Multiply':
Step 1: Open a new spreadsheet.
Step 2: Enter numbers into a spreadsheet.
Step 3: Select cell A3 which contains the number 3 and Press ‘Ctrl + C’ key combination to copy the value to
the Clipboard.
Step 4: Select the range A1:C3.
Step 5: Click on ‘Tools’ menu and then select ‘Macros’ option. A sub-menu appears on the screen. Click
‘Record Macro’ option to start the macro recorder.
216 Touchpad Information Technology-X

