Microsoft Office Tutorials and References
In Depth Information
Formatting Numbers, Dates, and Time Values
5. Click the AutoFill handle and start dragging in the direction in which
you want the data series to appear on your worksheet.
The AutoFill handle is the little green square in the lower-right corner
of the cell or block of cells you selected. As you drag, the serial data
appears in a pop-up box, as shown in Figure 1-6.
Figure 1-6:
Entering
serial data
and text.
The AutoFill Options button appears after you enter the serial data. Click it
and choose an option if you want to copy cells or fill the cells without
carrying along their formats.
To enter the same number or text in several empty cells, drag over the cells
to select them or select each cell by holding down the Ctrl key as you click.
Then type a number or some text and press Ctrl+Enter.
Formatting Numbers, Dates, and Time Values
When you enter a number that Excel recognizes as belonging to one of its
formats, Excel assigns the number format automatically. Enter 45% , for
example, and Excel assigns the Percentage number format. Enter $4.25 , and
Excel assigns the Currency number format. Besides assigning formats by
hand, however, you can assign them to cells from the get-go and spare
yourself the trouble of entering dollar signs, commas, percent signs, and other
extraneous punctuation. All you have to do is enter the raw numbers. Excel
does the window dressing for you.
Search JabSto ::




Custom Search