Page 162 - IT_V1.0_Class10
P. 162
Using the Macro Recorder
When LibreOffice Calc is first installed in your system, the macro recording feature is not activated in your
system. To enable the macro recording option:
Step 1: Select the Tools menu from the Menu bar.
Step 2: Select the Options option from the submenu. The Options - LibreOffice dialog box opens.
Step 3: Select the Advanced option. The options related to advance features of LibreOffice displays on the
right-side of the Options dialog box.
Step 4: Select the Enable macro recording (may be limited) check box.
Step 5: Click on the OK button.
1
3
4
5
2
The Macro Recording features is enabled and Record Macro option will be visible under Tools Macros.
Recording Macros
The steps to create a macro that performs paste special with multiply are as follows:
Step 1: Create a new spreadsheet.
Step 2: Enter numbers into a spreadsheet.
Step 3: Select the cell B2.
Step 4: Press Ctrl + C key combination to copy the value to the clipboard.
Step 5: Select the range A1:B3.
Step 6: Click on the Tools menu from the Menu bar.
Step 7: Select the Macros option.
Step 8: Select the Record Macro option.
6
5
7 8
3
160 Information Technology Play (Ver 1.0)-X

