Excel 2010 For Dummies
Book image
Explore Book Buy On Amazon

The Formula bar in Excel 2010 displays the cell address and the contents — data or a formula — of the current cell. Use the Formula bar to enter or edit formulas and cell data and assign names to cells.

The Formula bar appears just below the Ribbon and is divided into three sections:

  • Name box: The left-most section that displays the address of the current cell

  • Formula bar buttons: The middle section that displays an indented circle on the left (used to narrow or widen the Name box) with the Insert Function button (labeled fx) on the right; you also see a Cancel (an X) and an Enter (a check mark) button in this middle section of the Formula bar when you enter or edit cell data

  • Cell contents: The third, right-most white area to the immediate right of the Insert Function button that takes up the rest of the bar and expands down as necessary for lengthy cell entries

    What you type appears in the current cell and on the Formula bar.
    What you type appears in the current cell and on the Formula bar.

The cell address that appears in the Name box consists of the current cell's column letter(s) followed by the row number, as in A1, the very first cell of each worksheet at the intersection of column A and row 1. The contents of the current cell are determined by the type of entry you make there: text or numbers if you just enter a label or a particular value, and the nuts and bolts of a formula if you enter a calculation.

When it comes to labeling the 16,384 columns of an Excel 2010 worksheet, our alphabet with its measly 26 letters is simply not up to the task. To make up the difference, Excel first 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 final column of the worksheet ends up being XFD so that the last cell in the 1,048,576th row has the cell address XFD1048576.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.

This article can be found in the category: