Microsoft Office Tutorials and References
In Depth Information
Entering Data in a Worksheet
Entering data with Flash Fill
Don’t look now, but Excel is peering over your
shoulder to see whether it can enter data for
you with Flash Fill, a mechanism whereby Excel
recognizes the data you want to enter and
offers to enter it on your behalf. When Excel
recognizes a pattern in the data and thinks it
can fill in a column for you, a ghostly image of
the data Excel wants to enter appears in the
column. Press Enter if you want to enter this
After you press Enter, the Flash Fill Options
button appears. Click it to open a menu with
options for Undoing Flash Fill and selecting
Flash Fill is useful for cleaning up worksheets
with data that you imported from a comma- or
tab-delimited file. Often this data arrives in a
mishmash with data from different categories
in the same column.
Entering time values
Excel recognizes time values that you enter in the following ways:
mm AM/PM
3:31 AM
ss AM/PM
3:31:45 PM
Here are some things to remember when entering time values:
Use colons: Separate hours, minutes, and seconds with a colon (:).
Time formats: To change to the ss AM/PM time format, select
the cells, go to the Home tab, open the Number Format drop-down list,
and choose Time (see Figure 1-5). You can also change time formats by
clicking the Number group button on the Home tab and selecting a time
format on the Number tab of the Format Cells dialog box.
AM or PM time designations: Unless you enter AM or PM with the time,
Excel assumes that you’re operating on military time. For example, 3:30
is considered 3:30 a.m.; 15:30 is 3:30 p.m. Don’t enter periods after the
letters am or pm (don’t enter a.m. or p.m.).
Search JabSto ::

Custom Search