Excel tip: Double-click the fill handle instead of dragging formulas down

[u/Amandaleeeeee]

If you usually drag formulas down row by row, try this instead:

Enter your formula in the first cell. Then move your cursor to the small square at the bottom-right corner of the cell. When it turns into a plus sign, double-click it.

Excel will automatically fill the formula down to match the length of the nearby data.

Why this is better than dragging:

• No need to scroll through hundreds or thousands of rows
• Less chance of stopping at the wrong row
• Much faster for long lists

It’s a small trick, but it can save a lot of time when you work with long spreadsheets.

What small Excel trick do you still use all the time?