Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 36 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 36

    Cell Range

                      A group of cells is known as a cell range. A range comprises of two or more selected cells and
                      those selected cells need not be adjacent to each other. Rather than a single cell address, you will
                      refer to a cell range using the cell addresses of the first and last cell in the cell range separated
                      by a colon. For example, a cell range that includes cells A1, A2, A3, A4 and A5 would be written
                      as A1:A5. Different types of cell ranges are:
                      Vertical/Column Range

                      Column range  is the  number  of selected cells spread  across the column. Here,  the selected
                      vertical/column range is C1:C6. The range of cell starts at C1 and ends at C6.

                      Horizontal/Row Range

                      Row range is the number of selected cells spread across the row. Here, the selected horizontal/
                      row range is A4:D4. The range of cells starts at A4 and ends at D4. This range of cells consists of
                      cell, namely A2, B2 ,C2 and D2.

                      Row and Column/Mixed Range

                      Mixed range is the number of selected cells spread across the row and column. Here, the selected

                      mixed range is C3:E9. The range of cell starts at C3 and ends at E9.

                     34     Premium Edition-VII

| 31 32 33 34 35 36 37 38 39 40 41 |