Fill formulas into adjacent cells. Select the cell that contains the formula that you want to fill into adjacent cells. Drag the fill handle across the cells that you want to fill. To choose how you want to fill the selection, click Auto Fill Options , and then click the option that you want.