206
If you want to apply an Excel formula to the whole column, a few little tricks that you can easily adopt will help you
Apply Excel formula to entire column: Auto fill
There are various ways to apply an Excel formula to an entire column. You can carry out automatic filling in the following way:
- Write your formula in the first cell of the column in which you want to apply it. Click on the cell to select it:
- Move the mouse pointer over the small square in the bottom right-hand corner of the selected cell. The mouse pointer should turn into a small cross.
- Hold down the left mouse button and drag the mouse pointer downwards over the desired number of cells to which you want to apply the formula.
- Release the mouse button to apply the formula to the selected cells.
Double-click to complete: Instructions
First enter your formula in the field provided.
- Double-click on a box. A black cross should now appear
- The formula is now applied to all cells in the column to the left of the double cross.
These mistakes can happen to you
If Excel no longer calculates or the instructions do not work when you apply the formula, there are various reasons for this. Small errors that you make can be the reason for this.
- For example, if Excel no longer calculates, the settings have changed or you have inadvertently changed the program. To do this, go to the “File ☻ Options ☻ Formulas ☻ Calculation options ☻ Automatic” tab.
- Confirm the changes to save the settings. The program should calculate as usual.
- If you do not drag correctly over the column to apply the formula, you must get hold of the so-called black knob. Only then will the application of the formula work.
