Microsoft Office Tutorials and References
In Depth Information
Entering and Filling in Data and Series
D2 to track each employee’s performance against goal and formatted the cell so it uses the
Percentage format. You now want to copy that value and formatting to column D for each
of the remaining rows. Here’s what this section of the worksheet looks like when we select
the range we want to ill.
To copy the contents and formatting from the top cell in this range to all other cells, press
Ctrl+D. If you prefer a menu-driven approach, click Fill (in the Editing group on the Home
tab) and then click Down. If the top cell contains a formula, that formula is copied (with
relative references) to the cells in the range below it. If the cell contains text or a number,
that entry is copied exactly. If the selection contains more than one column, the contents of
the first cell in each column of the range is copied to the cells beneath.
Using any of the Fill options completely replaces the contents of the destination cells.
If those cells contain valuable data, you lose that data. To avoid this problem, use
Ctrl+click to select the cells whose contents you want to replace and then use the
Ctrl+Enter shortcut we discuss earlier in this section to enter the text, constant, or
formula into only those selected cells.
A similar technique exists to ill a selection within a row. Enter the value, text, or formula in
the first cell, and select the range to the right where you want to ill. Press Ctrl+R, or click
Fill (in the Editing group on the Home tab) and then click Right. The Fill menu on the Home
tab contains Up and Left options as well; there are no corresponding keyboard shortcuts
for those operations.
Even more powerful is the ability to extend a series of numbers, dates, or values. To ill
in a series of numbers, enter the first value in the series and then select that cell and the
remainder of the range where you want the series to continue. We want to begin a series
with the year 1960, so we entered it in cell A2 and selected the balance of the range. Click
Fill (in the Editing group on the Home tab) and then click Series to display the dialog box
shown in Figure 11-4.