Microsoft Office Tutorials and References
In Depth Information
Adding the Column Titles
Creating a Basic
Worksheet
Figure 14-3:
Excel lets you create a
new, blank workbook
or a ready-made
workbook from a
template—just like
the ones you learned
about for Word back
in Chapter 7. For now,
choose “Blank
workbook” and then click
the big Create button
in the bottom-right
corner.
Adding the Column Titles
Excel allows you to arrange information in whatever way you like. There’s nothing
to stop you from scattering numbers left and right, across as many cells as you can.
However, one of the most common (and most useful) ways to arrange your
information is as a table, with headings for each column.
It’s important to remember that even for the simplest worksheet, the decisions you
make about what’s going to go in each column can have a big effect on how easy it
is to manipulate your information. For example, in a worksheet that stores a
mailing list, you could have two columns: one for names and another for addresses. But
if you create more than two columns, your life will probably be easier since you can
separate first names from street addresses from Zip codes, and so on. Figure 14-4
shows the difference.
You can, of course, always add or remove columns later. But you can avoid getting
gray hairs by starting a worksheet with all the columns you think you’ll need.
The first step in creating your worksheet is to add your headings in the row of cells at
the top of the worksheet (row 1). Technically, you don’t need to start right in the first
row, but unless you want to add more information before your table—like a title for
the chart or today’s date—there’s no point in wasting the space. Adding information
Search JabSto ::




Custom Search