Shortcut to Apply a Formula to an Entire Column in Excel [closed] September 28, 2022 by Tarik Try double-clicking on the bottom right hand corner of the cell (ie on the box that you would otherwise drag).