Fill formulas across and down with fixed references
Your goal: Build a price scenario table while keeping the base-price column, rate row and fixed fee in the right places.
Full task requirements
Fill C2:E4 with base price × (1 + rate) + fixed fee. Use the base in column B, the rate in row 1 and the fee in G2.
Price scenariosCopy to D2: select the source inputs
Given formula in C2
=$B2*(1+C$1)+$G$2| # | |||||
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 |
Step 1 of 3
Copy one column right
Choose the source cells this copy reads. The base-price column stays fixed, the rate row stays fixed, and the fee stays in one cell. Every unlocked part moves by the copy distance.
- Copy from
- C2
- Copy to
- D2
=$B2*(1+C$1)+$G$2
Select the source inputs in the worksheet
Choose every input read by the formula after copying to D2. Use Cells for separate inputs or Range for a complete prefix.