Microsoft Office Tutorials and References
In Depth Information
Title Bar. The title bar is at the top of the Excel window and displays the name of the
program (Microsoft Office Excel 2003) followed by the name of the active workbook, if
any. If the active workbook has any access restrictions or is shared, the workbook name
will be followed by a designation in brackets. If you’ve opened more than one copy of
the same workbook, the first name will be followed by , the second by , and so on. :2
Select All Button. The Select All button is the bare piece of real estate to the left of the
Column A header and above the Row 1 header; clicking it selects every cell in a
Command Bars. Menu bars and toolbars might look different, but underneath they work
exactly the same way. Clicking File, Save is no different from clicking the Save toolbar
button, so why have both systems, plus the Ctrl+S keyboard shortcut, in place? Because
different users prefer different methods.
Formula Bar. The formula bar, the long, white strip just above the column headers in a
worksheet, is where Excel displays the formula in the active cell. If there is no formula
in the active cell, the cell’s value appears on the formula bar. You can hide the formula
bar by clicking View, Formula Bar, which is a toggle (that means you click the bar to
turn it off, and click again to turn it back on).
Name Box. The name box is in the running as the most versatile element in the Excel
interface. If you have created a named range, as described earlier in this chapter, you can
select a range by clicking the down arrow to the right of the name box and clicking the
name you want to select (thereby outlining the cells in the named range). When you
don’t have a named range selected, the name box displays the reference of the active cell
(for example, A1), or the area selected while dragging. For instance, if you select an
area three rows high by ten columns wide, the name box displays 3R × 10C until you
release the mouse button, and then the name box displays the reference of the cell in
the upper-left corner of the selected range.
Note Knowing the precise dimensions of the area you’ve selected is helpful if you need
to paste a group of cells from another worksheet into the active worksheet.
Program Window Controls. The standard Windows program controls are positioned at the
top right of the Excel window: the Minimize button, the Restore button, the Maximize
button (which appears when the program window has been resized), and the Close
Workbook Window Controls. These buttons operate in exactly the same manner as the
program window controls, but they affect only the active workbook. (The Excel window
stays the same size it was when the buttons were clicked.)
Ask A Question Box. The Ask A Question box is the quickest way to look up topics in the
Excel help system. You type a word or phrase in the Ask A Question box, press Enter,
and a list of available help topics appears in the Search Results task pane at the right
edge of the workbook. Clicking the name of the help topic displays that topic.