Excel Study · Module 1: First steps
Class 6Fill handle: copy a formula down
Basics1:23 videoFree
Type a formula once, then drag the fill handle — the small square at the corner of the cell — to copy it down. Excel changes the references for each row by itself (B2*C2 becomes B4*C4 in row 4): that is a relative reference.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, row 2 has a price in B2 and a quantity in C2, and there are more rows below. Write a formula for the first row that I can drag down to the other rows.
The answer that works
✓ checked in Excel=B2*C2
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.