Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
Having fun with the Formula bar
The Formula bar displays the cell address (determined by a column letter(s)
followed by a row number) and the contents of the current cell. For example,
cell A1 is the first cell of each worksheet at the intersection of column A and
row 1; cell XFD1048576 is the last cell of each worksheet at the intersection
of column XFD and row 1048576. The type of entry you make determines the
contents of the current cell: text or numbers, for example, if you enter a
heading or particular value, or the details of a formula, if you enter a calculation.
The Formula bar has three sections:
✓ Name box: The left-most section that displays the address of the current
✓ Formula bar buttons: The second, middle section that appears as a
rather nondescript button displaying only an indented circle on the left
(used to narrow or widen the Name box) and the Insert Function button
(labeled fx) on the right. When you start making or editing a cell entry,
Cancel (an X) and Enter (a check mark) buttons appear between them.
✓ Cell contents: The third, right-most white area to the immediate right
of the Insert Function button takes up the rest of the bar and expands
as necessary to display really long cell entries that won’t fit in the
The cell contents section of the Formula bar is important because it always
shows you the contents of the cell even when the worksheet does not. (When
you’re dealing with a formula, Excel displays only the calculated result in the
cell in the worksheet and not the formula by which that result is derived.)
Additionally, you can edit the contents of the cell in this area at any time.
Similarly, when the cell contents area is blank, you know that the cell is empty
How you assign 26 letters to 16,384 columns
When it comes to labeling the 16,384 columns
of an Excel 2013 worksheet, our alphabet with
its measly 26 letters is simply not up to the task.
To make up the difference, Excel doubles the
letters in the cell’s column reference so that
column AA follows column Z (after which you
find column AB, AC, and so on) and then triples
them so that column AAA follows column ZZ
(after which you get column AAB, AAC, and the
like). At the end of this letter tripling, the 16,384th
and last column of the worksheet ends up being
XFD so that the last cell in the 1,048,576th row
has the cell address XFD1048576!