Excel Study · Module 2: Entering & formatting data
Class 13AutoFill: days, months, 1-2-3
Basics1:27 videoFree
Type Mon and drag the fill handle: Excel fills Tue, Wed … Sun. Months work the same way. A single number only copies itself — give Excel two numbers (1 and 2) and it continues the pattern: 3, 4, 5.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, write a formula for D2 that shows 1, and counts up 2, 3, 4 in the rows below when I fill it down column D.
The answer that works
✓ checked in Excel=ROW()-1
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.