Microsoft Office Tutorials and References
In Depth Information
Using the Fill Handle to Copy a Cell to Adjacent Cells
• Tap or click cell C19
to complete the
indicated by the
formula, to display
the result in the
worksheet, and to
select the cell to the
right (Figure 1– 28).
cell C19 selected
Figure 1– 28
To Copy a Cell to Adjacent Cells in a Row
The easiest way to copy the SUM formula from cell B19 to cells C19, D19, E19,
F19, G19, H19, I19, J19, K19, L19, M19, and N19 is to use the fill handle. The following
steps use the fill handle to copy the formula in cell B19 to the adjacent cells C19:N19.
Select cell B19.
Drag the fill handle to select the destination area, range C19:N19, to display a shaded
border around the source area and the destination area. Do not lift your nger or release
the mouse button.
Lift your nger or release the mouse button to copy the simple formula function from
the active cell to the destination area and calculate the results.
To Save a Workbook with a New File Name
You have performed many tasks while creating this workbook and do not want
to risk losing work completed thus far. Accordingly, you should save the workbook on
your hard disk, SkyDrive, or a location that is most appropriate to your situation.
The following steps assume you already have created folders for storing your
les, for example, a CIS 101 folder (for your class) that contains an Excel folder
(for your assignments). Thus, these steps save the workbook in the Excel folder in the
CIS 101 folder on your desired save location. For a detailed example of the procedure
for saving a le in a folder or saving a le on SkyDrive, refer to the office and
Windows chapter at the beginning of this topic.