How you would use the autofill shortcut?

Answer 1

To use the autofill shortcut, first, enter a value in a cell and then click and drag the fill handle—the small square at the bottom-right corner of the cell—down or across adjacent cells. Alternatively, you can double-click the fill handle to autofill a range based on adjacent data. This feature is useful for quickly populating a series or copying formulas without manually entering them in each cell.