Basics


What is a cell?

    Excel is structured using workbooks. A workbook is a collection of sheets, which each contain individual pieces of data, stored in cells. The title of the workbook can be found on the title bar (Figure 1).

(Figure 1) 

(Figure 2)

     By default there are three sheets in a workbook, as shown in Figure 2. Additional sheets may be added, as well as removed by using the menu brought by right clicking the sheet's tab (Figure 2). Each cell in sheets can contain data of varying types, including text, numbers, and formulas.

    Cells can be selected in two ways, clicking and entering the cells address in the name box, shown in (Figure 3). A cell's address serves as a means of referring to a cell. Addresses have the format, <Column><Row>. For example, the upper-left most cell is A1. A range of cells is represented by the upper-left most cell and the lower-right most cell separated by a colon. 

(Figure 3)

    Once a cell has been selected, information can be copied and pasted to other cells. Keep in mind if formulas are copied, the cell references in the formulas are updated for the new cell (see Formulas).

Cell Naming

    In addition to an address, a cell can be referred to by a name. Names can be applied to individual cells and a range of cells. To manage cell names go to Insert ->Name ->Define. This will bring the dialog show below.

(Figure 4)

    In this dialog, the name is entered in the "Names in workbook:" field. The address of the cell(s) represented by the name is entered under "refers to." Once a cell has been named, a cell may be referred to by the name, instead of the address


Copyright 2008 David Coss davecoss.com