Microsoft Office Tutorials and References
In Depth Information
Entering and revising data
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 enter 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 that lists 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 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. By 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 enter 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 the end value you want.
Search JabSto ::

Custom Search