In Excel cell function and references are helpful to better understand Excel spreadsheets. Use Excel cell reference functions as well.
You can also double-click the fill handle instead of clicking and dragging. This can be useful with larger spreadsheets, where clicking and dragging may be awkward.
Watch the video below to see an example of double-clicking the fill handle.