Page 41 - ICT_for_JHS_3_Classical
P. 41

Fill and Series Pop up options


               Alternative C
                       1.  Select the first cell in the range that you want to fill. (e.g. A3)

                       2.  Type the starting value for the series. (e.g. type 1 in A3)
                       3.  Type a formula in the next cell to establish a pattern. (e.g. =A3+1)
                       4.  Select the cells that contain the starting formula (e.g. A4)
                       5.  Drag the fill handle           across the range that you want to fill. (e.g.
                          A4:A10)




















               Use function to number rows or columns

                      1.  Select the first cell in the range that you want to fill. (e.g. A3)
   36   37   38   39   40   41   42   43   44   45   46