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
   225   226   227   228   229   230   231   232   233   234   235