Datasheet

3. Click the Add button to add the command button to the bottom of the
list box on the right.
4. (Optional) To reposition the newly added command button so that it’s
not the last one on the toolbar, click the Move Up button until it’s in
the desired position.
5. Click the OK button to close Excel Options dialog box.
If you’ve created favorite macros (see Chapter 12) that you routinely use and
want to be able to run directly from the Quick Access toolbar, click Macros in
the Choose Commands From drop-down list box in the Excel Options dialog
box and then click the name of the macro to add followed by the Add button.
Having fun with the Formula bar
The Formula bar displays the cell address and the contents of the current
cell. The address of this cell is determined by its column letter(s) followed
immediately by the row number as in cell A1, the very first cell of each work-
sheet at the intersection of column A and row 1 or cell XFD1048576, the very
last of each Excel 2007 worksheet, at the intersection of column XFD and row
1048576. The contents of the current cell are determined by the type of entry
you make there: text or numbers if you just enter a heading or particular
value and the nuts and bolts of a formula if you enter a calculation there.
The Formula bar is divided into three sections:
 Name box: The left-most section that displays the address of the current
cell address
 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) with the Function Wizard
button (labeled
fx) on the right until you start making or editing a cell
entry at which time, its Cancel (an
X) and its Enter (a check mark) but-
tons appear in between them
 Cell contents: The third, right-most white area to the immediate right of
the Function Wizard button that takes up the rest of the bar and expands
as necessary to display really, really long cell entries that won’t fit the
normal area
The Cell contents section of the Formula bar is really 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)
and you can edit the contents of the cell in this area at anytime. By the same
token, when the Contents area is blank, you know that the cell is empty as well.
21
Chapter 1: The Excel 2007 User Experience
05_037377 ch01.qxp 11/16/06 9:23 AM Page 21