Microsoft Office Tutorials and References
In Depth Information
Adding the Column Titles
Creating a Basic
is easy—just click the cell you want and start typing. When you’re finished, hit Tab
to complete your entry and move to the next cell to the right (or Enter to head to the
cell just underneath).
Figure 14-4:
Top: If you enter the
first and last names
together in one
column, Excel can
sort only by the first
names. And if you
clump the addresses
and Zip codes
together, you give Excel
no way to count how
many people live in a
certain town or
neighborhood because
Excel can’t extract the
Zip codes.
Bottom: The benefit
of a six-column table
is significant: It lets
you sort (reorganize)
your list according to
people’s last names
or where they live.
It also allows you to
filter out individual
bits of information
when you start using
functions later in this
Note: The information you put in an Excel worksheet doesn’t need to be in neat, ordered columns.
Nothing stops you from scattering numbers and text in random cells. However, most Excel worksheets
resemble some sort of table, because that’s the easiest and most effective way to deal with large amounts
of structured information.
For a simple expense worksheet designed to keep a record of your most prudent and
extravagant purchases, try the following three headings:
Date Purchased stores the date when you spent the money.
Item stores the name of the product that you bought.
Price records how much it cost.
Right away, you face your first glitch: awkwardly crowded text. Figure 14-5 shows
how you can adjust column width for proper breathing room.
Search JabSto ::

Custom Search