The spreadsheet data area takes up most of the NExS window. The spreadsheet is a rectangular grid made up of columns (identified by letters) and rows (identified by numbers). Each block within this grid is a cell, which is where you enter data and formulas. For spreadsheets larger than the window, NExS shows only part of the spreadsheet on screen at a time. To access other areas, you can scroll through the spreadsheet using the scroll bars or arrow keys on your keyboard. The NExS spreadsheet area includes column and row buttons and cells.
A horizontal row of buttons above the spreadsheet data area that identify each column of cells in the spreadsheet (4096 in all). The first 26 columns are labeled with single letters (A to Z); the remaining columns are labeled with double and triple letters (AA to FAN). The column of the current selection is highlighted in reverse video or a different color, depending on your monitor. Clicking a column button selects the entire column of cells. Dragging the right edge of a column button resizes the column.
A vertical column of buttons to the left of the spreadsheet data area that identify each row (1 to 32,767) of cells in the spreadsheet. The row of the current selection is highlighted in reverse video or a different color, depending on your monitor. Clicking a row button selects the entire row of cells. Dragging the bottom edge of a row button resizes the row.
A push button at the intersection of the row and column buttons (in the upper left section of the NExS display) selects all cells in the spreadsheet: A1..FAN32767.
Formulas are viewed and changed in the Edit Line; they appear only when the cell is highlighted. A rectangle in the body of the sheet indicates the current cell. This is the cell that will be affected by your next action. Each cell is identified by an address that contains the column and row coordinates in the matrix. For instance, the address of the first cell in the spreadsheet is always A1; the cell in column D, row 4 has the cell address D4. With 4096 columns and 32,767 rows, the NExS spreadsheet contains more than 134 million cells. However, the actual size of your spreadsheet is limited by the memory capacity of your computer system, which is usually far less than the capacity of the spreadsheet.
The amount of information in each cell and the nature of the entries themselves determine how many cell entries you can make before you run out of memory. There is a good reason, though, for NExS to provide a spreadsheet grid larger than you can ever fill; it gives you the flexibility to develop long, narrow spreadsheets or wide ones with few rows.
A cell range is a rectangular group of cells that are grouped so that operations or formulas act on several cells at once. Ranges are identified by the cell addresses of two opposite corners, usually the top left and bottom right corners.
NExS contains the primary spreadsheet data area which has all of the elements shown in Figure 2.1. In addition, you may create multiple secondary windows of the spreadsheet data area which are displayed as popup windows. Secondary windows contain only the spreadsheet data and scrolling bars. They do not have a menu bar, edit line, and message line.
Each secondary window can be sized, navigated, and manipulated independently using the main menu bar along with standard scrolling and window management facilities. To create a secondary data window:
To remove a secondary data window:
Because the spreadsheet display can show only part of a large spreadsheet, you may need to scroll through the spreadsheet to view other sections (or create a secondary window). Scroll bars, which appear on the right and bottom edges of the spreadsheet view, allow you to scroll through the spreadsheet just as though it were printed on a continuous roll of paper. On each scroll bar, a slider bar indicates:
If the slider fills the entire scroll bar, then the current view displays the entire spreadsheet.
To move the view left or right one column at a time:
To move the view up or down one row at a time:
To move the view anywhere in the spreadsheet:
To move the view to the top or bottom of the used portion of the spreadsheet: