gogollka.blogg.se

Here, first we will use the combination of ALT + H + F + I + S keys and then ALT + F keys to drag formula in a column. Method-7: Using Combination of ALT+H+F+I+S and ALT+F Keys

Read More: How to Use Fill Handle to Copy Formula in Excel (2 Useful Examples) First, we will type the following formula in cell E5 to add up cells C5 and this formula adds up the Salary column with the Increment column.Here, we will use the SHIFT + Down Arrow key to select cells in a column, after that, we will press CTRL + D to drag down the formula. Method-3: Using SHIFT+Down Arrow & CTRL+D to Drag Formula Down Read More: Excel Drag to Fill Not Working (8 Possible Solutions) After that, press SHIFT + ENTER, this will select the cells from E5 to E12.In the Reference box, we will type E12, as we want to drag the formula to cell E12.Then, we will select cell E5 and type CTRL + C to copy the cell.First, we will type the following formula in cell E5 to add up cells C5 and D5.Here, we will type CTRL + C to copy a formula, after that, we will press the F5 key to bring out Go To window and we will type CTRL + V to drag formula with keyboard. Method-2: Use of CTRL+C, F5, and CTRL+V Keys to Drag Formula in Excel with Keyboard Read More: How to Enable Drag Formula in Excel (With Quick Steps) Afterwards, we will type CTRL + V in the rest of the cells of the Total Salary column.įinally, we can see the result of the Drag Formula in Excel with Keyboard.After that, we will select cell E6 by using SHIFT + Down Arrow then type CTRL + V.Next, we will select cell E5 > then press CTRL + C.Here, this formula simply adds cell C5 with cell D5.