Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
• Repeat Steps 1 and 2 to adjust the column width of columns B through N (Figure 1– 52).
columns B through
Figure 1– 52
1 ENTER TEXT | 2 CALCULATE TOTALS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Use the Name Box to Select a Cell
The next step is to chart the monthly expenses. To create the chart, you rst must select the cell in
the upper-left corner of the range to chart (cell A3). Rather than tapping or clicking cell A3 to select it, the
next section describes how to use the Name box to select the cell. The Name box is located on the left side of
the formula bar. Why? To select any cell, tap or 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.
• Tap or click the Name box in the
formula bar and then type a3
as the cell you want to select
(Figure 1– 53).
Why is cell A7 still selected?
The current cell will remain
selected until you press the
in Name box
Figure 1– 53