The spreadsheet window

The area in which you work on a spreadsheet is called the spreadsheet window. The different areas of the spreadsheet window are shown on this diagram:

image\sp4.gif

Clicking on a column letter on the column bar selects that column, while clicking on a row number on the row bar selects that row. You can select multiple rows or columns by dragging the cursor across several row or column bars, or you can select the entire sheet by clicking the button at the intersection of the row and column bars.

A spreadsheet is organized into rows and columns, like a table. The rows are numbered sequentially down the left edge of the spreadsheet window. The columns are labeled with letters across the top of the spreadsheet window. (The column letters run sequentially from A to Z, then from AA to AZ, then from BA to BZ, and so on, finally ending with IA to IV).

The maximum size for a spreadsheet is 65,536 rows and 256 columns.

Each Ability spreadsheet has up to 255 associated worksheets – 3 by default (See General options). These allow you to work with related information from different worksheets, which are then stored in the one spreadsheet file.

See also:

The toolbars and formatting bar

The formula bar

Worksheets