Microsoft Office Tutorials and References
In Depth Information
Using the Name Box to Select a Cell
2
Double-click on the boundary to
adjust the width of the column to
the width of the largest item in the
column (Figure 1– 50).
What if none of the items in column
A extends through the entire width
of the column?
If all of the items in column A were
shorter in length than the width
of the column when you double-
click the right side of the column
A heading, then Excel still would
adjust the column width to the
largest item in the column. That is,
Excel would reduce the width of the
column to the largest item.
mouse pointer
new column A width
Figure 1–50
Using the Name Box to Select a Cell
The next step is to chart the lifetime fundraising amounts for the i ve fundraising activities
used by the organization. To create the chart, you i rst must select the cell in the upper-
left corner of the range to chart (cell A3). Rather than clicking cell A3 to select it, the
next section describes how to use the Name box to select the cell.
To Use the Name Box to Select a Cell
The Name box is located on the left side of the formula bar. To select any cell, click the Name box and enter
the cell reference of the cell you want to select. The following steps select cell A3 using the Name box.
1
Click the Name box in the formula
bar and then type a3 as the cell
you wish to select (Figure 1– 51).
a3 typed in
Name box
Why is cell A11 still selected?
Even though cell A11 is the active
cell, Excel displays the typed cell
reference a3 in the Name box until
you press the ENTER key.
A11 is active cell
Figure 1–51
 
Search JabSto ::




Custom Search