SESSION 4: CREATE AND USE MACROS IN SPREADSHEET
Hello friends, Here you will find the important notes of CBSE Class 10 Information Technology Code 402. In this post you will find UNIT 2 ELECTRONIC SPREADSHEET (ADVANCED) Notes. In it SESSION 4: CREATE AND USE MACROS IN SPREADSHEET is defined for good understanding the concepts of MACROS in Spreadsheets. You can also find the SESSION 1, 2, 3 Notes here.
CREATE AND USE MACROS IN SPREADSHEET
Macros:
A macro is a saved sequence of commands or keystrokes that are stored for later use. Macros are especially useful to repeat a task the same way over and over again.
Using the macro recorder:
- Use Tools > Macros > Record Macro to start the macro recorder.
- The Record Macro dialog is displayed with a stop recording button.
- Click Stop Recording to stop the macro recorder.
Advantage of using Macro:
- Macros automates the repetitive and routine tasks.
- Macros speed up process and reduce time.
Sorting:
Sorting data can be automated in Open Office by creating a Macro in Calc. Data can be sorted on a single column or more than one column. Each time the Macro runs the data gets sorted.