Excel Cells

Use:

Cells can contain character data (also know as string data), numeric data, time/date data, or Excel formulas. A cell can only contain one item at a time.

Syntax:

Each spreadsheet cell has a unique address of the form Sheet!ColRow

Sheet Name

By default, the sheets are named Sheet1, Sheet2, ...

Sheets can be renamed and rearranged by the user.

Column Label

The left-to-right column order is A, B, C, ... X, Y, Z, AA, AB, AC, ...

Column labels (and all cell formulas that reference them) are automatically updated when columns are rearranged, inserted or deleted.

Row Number

The top-to-bottom row order is 1, 2, 3 ...

Row numbers (and all cell formulas that reference them) are automatically updated when rows are rearranged, inserted or deleted.

Examples:

Cell Sheet1!F2 ( or simply F2 ) contains the character string "Apr"

Cell Sheet1!F5 ( or simply F5 ) contains the number 739

Cell Sheet1!F9 ( or simply F9 ) is empty

Cell Sheet1!H6 ( or simply H6 ) contains the formula   =SUM( C6:G6 )

Cell Sheet1!I8 ( or simply I8 ) contains the formula   =B8

 

Note:

The sheet portion of a cell address can be skipped in a formula if the cell is on the same sheet as the formula. This simplifies typing as well as readability.

Related Topics:

Cell Ranges, Relative & Absolute Addresses

    Home | Lectures | Handouts | Assignments |

This website was originally developed by John Mote for his MIS 311F class. This site is now maintained by the Department of Civil Engineering at the University of Memphis. Your comments and questions are welcomed.