Microsoft Office Tutorials and References
In Depth Information
I discuss names in Chapter 3. As you can see there, Excel handles names in some unique
Selecting objects in Excel conforms to standard Windows practices. You can select a range of
cells by clicking and dragging. (Learning the keyboard shortcuts is more efficient, however.)
Clicking an object that has been placed on the drawing layer selects the object. To select multiple
objects or noncontiguous cells, press Ctrl while you select the objects or cells.
Clicking a chart selects a specific object within the chart. To select the chart object
itself, press Ctrl while you click the chart.
If an object has a macro assigned to it, clicking the object executes the macro. To actually select
such an object, right-click it and press Esc to hide the shortcut menu. Or press Ctrl while you click
Excel provides two types of formatting: numeric formatting and stylistic formatting.
Numeric formatting refers to how a number appears in the cell. In addition to choosing from an
extensive list of predefined formats, you can create your own formats (see Figure 2-16). The
procedure is thoroughly explained in the Help system.
Excel applies some numeric formatting automatically, based on the entry. For example, if you
precede a number with a currency symbol (a dollar sign in the United States), Excel applies
Currency number formatting. You can also use the conditional formatting feature to apply
number formatting conditionally, based on the magnitude of the number.
Stylistic formatting refers to the formatting that you apply to make your work look good. Many
Ribbon buttons offer direct access to common formatting options, but you’ll want to access the
object’s Format dialog box for the full range of formatting options.
The easiest way to get to the correct dialog box and format an object is to select the object and
press Ctrl+1. You can also right-click the object and choose Format xxx (where xxx is the selected
object) from the shortcut menu. Either of these actions brings up a tabbed dialog box that holds
all the formatting options for the selected object.