In Excel cell function and references are helpful to better understand Excel spreadsheets. Use Excel cell reference functions as well.
If you're copying cell content to adjacent cells in the same row or column, the fill handle is a good alternative to the copy and paste commands.
The fill handle can also be used to continue a series. Whenever the content of a row or column follows a sequential order, like numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the fill handle can guess what should come next in the series. In most cases, you will need to select multiple cells before using the fill handle to help Excel determine the series order. Let's take a look at an example:
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.