Microsoft Office Tutorials and References
In Depth Information
Quickly Entering Lists and Serial Data with the AutoFill Command
✦ Current time: Press Ctrl+Shift+; (semicolon) to enter the current time.
✦ Times on the Formula bar: On the Formula bar, times are displayed in
this format: hours :minutes :seconds, followed by the letters AM or PM.
However, the time format used in cells is up to you.
Combining date and time values
You can combine dates and time values by entering the date, a blank space,
and the time:
✦ 7/31/13 3:31 am
✦ 7-31-13 3:31:45 pm
Quickly Entering Lists and Serial Data
with the AutoFill Command
Data that falls into the “serial” category — month names, days of the week,
and consecutive numbers and dates, for example — can be entered quickly
with the AutoFill command. Believe it or not, Excel recognizes certain kinds
of serial data and enters it for you as part of the AutoFill feature. Instead of
laboriously entering this data one piece at a time, you can enter it all at one
time by dragging the mouse. Follow these steps to “autofill” cells:
1. Click the cell that is to be first in the series.
For example, if you intend to list the days of the week in consecutive
cells, click where the first day is to go.
2. Enter the first number, date, or list item in the series.
3. Move to the adjacent cell and enter the second number, date, or list
item in the series.
If you want to enter the same number or piece of text in adjacent cells,
it isn’t necessary to take this step, but Excel needs the first and second
items in the case of serial dates and numbers so that it can tell how
much to increase or decrease the given amount or time period in each
cell. For example, entering 5 and 10 tells Excel to increase the number
by 5 each time so that the next serial entry is 15.
4. Select the cell or cells you just entered data in.
To select a single cell, click it; to select two, drag over the cells. Chapter
2 of this mini-book describes all the ways to select cells in a worksheet.