Microsoft Office Tutorials and References
In Depth Information
Formatting Numbers and Labels
You can also type in a sequence of numbers in Step 1. So if you typed
the numbers 2, 4, and 6 in adjacent cells, highlighted all these adjacent
cells, and grabbed the Fill Handle, Excel is smart enough to detect the
pattern and display the numbers 8, 10, and 12 in the next three adjacent
cells.
2. Move the mouse pointer over the Fill Handle until the mouse pointer
turns into a black crosshair icon.
3. Hold down the left mouse button and drag (move) the mouse down a
column or across the row.
As you drag the mouse, Excel automatically types in the remaining
month or day names, as shown in Figure 8-2.
Figure 8-2:
By
dragging the
Fill Handle,
Excel
automatically
enters the
names of
the month
or days.
Formatting Numbers and Labels
When you first create a spreadsheet, numbers and labels appear as plain
text. Plain labels might look boring, but plain numbers (such as 8495 or 0.39)
can be difficult to read and understand if the numbers are supposed to
represent currency amounts ($8,495) or percentages (39%).
 
Search JabSto ::




Custom Search