Administration and Executive AssistantTier 120 minbeginner

Lock It With $: Fill Down and Across

Lock the right part of each reference so one formula fills a whole price table without breaking.

What you will learn

• Lock a single rate cell with $ so it survives being filled down
• Use $B4 to keep the column fixed and D$3 to keep the row fixed
• Press F4 to cycle through A1, $A$1, A$1 and $A1
• Check the last cell of a filled range, where an unlocked reference shows up

Excel skills

$A$1, $A1, A$1, F4, fill down and across · Cell References

The task

Two jobs on the Prices tab, and I want each one done with a single formula that is filled, not typed row by row.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free