The behavior of the fill handle varies depending on the content of the cell or range selected: When an adjacent column contains values, double-clicking the fill handle will extend values down the worksheet to match, following the behaviors described above. Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.