Email this article
Fill
Edit > Fill
You can choose the Fill option that suits your needs:
Fill Down (Ctrl
+ D)
With the desired cells highlighted, click this command, and all the
cells will fill with the same number (or formula) as the first one. 
(Show me...)
Fill Right (Ctrl
+ R)
This is similar to Fill Down. Highlight the desired cells (the one you
are copying, and ones to its right which you are filling in), then use
this command to copy from one cell across the whole row.
(Show me...)
| $2,000
|
$2,000
|
$2,000
|
$2,000
|
$2,000
|
$2,000
|
$2,000
|
$2,000
|
$2,000
|
You can copy values or formulas
- relative column references in formulas will adjust as they fill in.
| $100
|
$150
|
$225
|
$338
|
$506
|
$759
|
$1,139
|
$1,709
|
$2,563
|
Additional Detail
Fill Right will have different results when copying formulas
with relative
vs. absolute cell references. In the first example below, cell C3 contained a formula:
= C4+2
That is, cell C3=the cell
directly below it +2. This is a relative cell reference, because the cell specified is relative to the one in which the formula occurs.
When we used the Fill Right command across row 3, starting with this formula in cell C3, the formula with
a relative cell reference was copied to all the other cells. Each cell in row 3 now equals the value
in the cell directly beneath it (row 4), plus 2.
|
|
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
K
|
| 3
|
$22
|
$42
|
$32
|
$2
|
$28
|
$10
|
$18
|
$7
|
$72
|
| 4
|
$20
|
$40
|
$30
|
$0
|
$26
|
$8
|
$16
|
$5
|
$70
|
You can also use an absolute cell reference: If cell C3 contained the
formula
=$C4+2
the reference
to the C
column would absolute. In this example, the Fill Right
command makes ALL cells in row 3 equal the value of cell C4,
plus 2.
|
|
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
K
|
| 3
|
$22
|
$22
|
$22
|
$22
|
$22
|
$22
|
$22
|
$22
|
$22
|
| 4
|
$20
|
$20
|
$30
|
$0
|
$26
|
$8
|
$16
|
$5
|
$70
|
Related Topics
