Step 2: Dragging the autofill handle to the bottom of the target part in the column B. We first type the formula into the cell B1. Step 1: Typing the formula in the first cell of column B. Part 1: Dragging the autofill handle to apply a formula to the entire column or row in Excel Typically there are two ways to actualize this goal: dragging or not dragging autofill handle. Now we suppose that you would like to apply a formula of A1*6-5 in the column B. Then how can we apply a formula to the entire columns or rows in Excel? Just continue reading the below. As far as I am concerned, manually typing a formula just fit the situation that you just want to apply a formula in one cell of the Excel table, but if you manually apply the same formula to all the cells or rows in Excel, that would be really an annoying thing. For saving time and improving working efficiency, some people would like to apply a formula to an entire column or row in excel.
In the modern office working, people usually use Excel to demonstrate some data reports. Need to Apply a Formula to an Entire Column or Row in Excel
