Specifying Cell Ranges and Locations

 

 

In Predictive Systems Lab, document data is organized in workbooks, where a workbook is a collection of worksheet pages. Each worksheet in turn, is organized into a number of rectangular cells, ordered by horizontal rows and vertical columns. The maximum number of worksheets allowed for any document in Predictive Systems Lab is 256. The maximum number of rows and columns allowed in any one worksheet in Predictive Systems Lab is of 4,194,303 rows and 8,192 columns, up to a maximum of 268,435,456 cells.  In this fashion, a worksheet can be filled to the limit with 64 columns of 4,194,303 rows, as with 8,192 columns of 32,768 rows, for example. Note that the capacity of your computer to reach this limit also depends on the amount of RAM available in your computer.

 

Columns are numbered using the letters of the alphabet; rows, using ordinary numbers. Any one cell can be identified by its location, which is specified by the column letter followed by the row number, as in A1, B5, and BE2, for example.

 

Cell ranges, on the other hand, are specified by supplying an upper-right and a lower-left cell location, separated by a colon (:) or two dots (..). As an example, the range of selected cells in the figure above (highlight) can be expressed as either A3:C8 or A3..C8.  The term range position is used throughout this Help to denote the location of a range's upper-right cell within a worksheet.