Page 189 - Computer - 10(A&B)

Session 4

Create and Use Macros in Spreadsheet

A macro is a set of commands or keystrokes that are stored for later use. You can use macros to automate both
simple and complex tasks. Macros are useful especially when you have to repeat a task multiple of times in the
same way.

Using the Macro Recording
If you want to record a macro, it is necessary to enable macro recording.
To enable macro recording:
Step 1: Go to Tools  Options. The Options dialog box opens.

Step 2: Select LibreOffice  Advanced and check the option Enable macro recording under Optional Features.
By default, this feature is turned off in LibreOffice. Click the OK button.

Check it open

To Record a Macro
Step 1: Click on ToolsMacro Record Macro option.

71