Microsoft Office Tutorials and References
In Depth Information
Entering and Revising Data
After you create a workbook, you can begin entering data. The simplest way to enter data
is to click a cell and type a value. This method works very well when you’re entering a few
pieces of data, but it is less than ideal when you’re entering long sequences or series of
values. For example, Craig Dewar, the VP of Marketing for Consolidated Messenger, might
want to create a worksheet listing the monthly program savings that large customers can
realize if they sign exclusive delivery contracts with Consolidated Messenger. To record
those numbers, he would need to create a worksheet tracking each customer’s monthly
program savings.
Repeatedly entering the sequence January, February, March, and so on can be handled
by copying and pasting the first occurrence of the sequence, but there’s an easier way to
do it: use AutoFill. With AutoFill, you enter the first element in a recognized series, click
and hold the mouse button down on the ill handle at the lower-right corner of the cell,
and drag the ill handle until the series extends far enough to accommodate your data.
Using a similar tool, FillSeries, you can enter two values in a series and use the ill handle
to extend the series in your worksheet. For example, if you want to create a series starting
at 2 and increasing by 2, you can put 2 in the first cell and 4 in the second cell, select
both cells, and then use the ill handle to extend the series to your desired end value.
Search JabSto ::

Custom Search