Lesson 2: A Faster Way to Use the Fill Handle /en/excel-tips/add-the-current-date-to-a-cell/content/ A faster way to use the fill handle If you're copying cell content to adjacent cells, you can click and drag the fill handle (the small square in the lower-right corner of the selected cell). However, with larger spreadsheets this can be awkward because you'll have to hold down your mouse button and wait for Excel to scroll to the bottom of your sheet. Luckily, there's a shortcut: Simply double-click the fill handle, and it will instantly copy the cell content down. Watch the video below to see this shortcut in action.
Nov 3, 2016 - The Fill Handle in Excel allows you to automatically fill in a list of data (numbers or text) in a row or column simply by dragging the handle. Nov 6, 2018 - Learn how to copy data to multiple cells in Excel using the keyboard, the Fill. To Excel versions 2019, 2016, 2013, 2010, Excel Online, and Excel for Mac. Click and hold the fill handle in the bottom right corner of the cell that.