Page 5 of 23PREVNEXT

Get to know Excel 2007: Create your first workbook

Column and row headings in worksheet

After the first 26 column headings (A through Z), the next 26 column headings are AA through AZ. The column headings continue through column XFD, for a total of 16,384 columns.
Callout 1 Column headings are indicated by letters.
Callout 2 Row headings are indicated by numbers.

Worksheets are divided into columns, rows, and cells. That's the grid you see when you open up a workbook.

Columns go from top to bottom on the worksheet, vertically. Rows go from left to right on the worksheet, horizontally. A cell is the space where one column and one row meet.

Each column has an alphabetical heading at the top. The first 26 columns have the letters from A through Z. Each worksheet contains 16,384 columns in all, so after Z the letters begin again in pairs, AA through AZ. See Figure 2.

After AZ, the letter pairs start again with columns BA through BZ, and so on, until all 16,384 columns have alphabetical headings, ending at XFD.

Each row also has a heading. Row headings are numbers, from 1 through 1,048,576.

The alphabetical headings on the columns and the numerical headings on the rows tell you where you are in a worksheet when you click a cell. The headings combine to form the cell address, also called the cell reference. You'll learn more about this in the next section.

Page 5 of 23PREVNEXT