Page 230 - IT 402 v2.0 class 10
P. 230
Sorting the Columns Using Macro
In this example we re sorting data stored in different cells in ascending order by using macro.
In the beginning, data stored in cell A1 to A6 looks like:
Step 1: Select the cell in which data is stored. Here, we have selected A1 to A6 cells. A submenu appears on
the screen. Select ‘Record Macro’ option.
Step 2: Click on ‘Tools’ menu.
Step 3: Select ‘Macros’ option.
Step 4: Click on ‘Sort Ascending’ option.
2
1
3
4
228 Touchpad Information Technology-X

