Now select the entire column-This applies even for the Row. Just make sure that the formula is placed first on the cell of the column or the row you want to use. To do so, use the steps provided below:Įnter the formula to the first cell C1=(A1*X+N)/T. It is also another way of adding the same formula to the entire row or column easily and quickly.
On Excel Ribbon, there's a FILL Feature that you can make full use of. You can perform the above operations the same way and end up getting the same results using the Fill Feature. After this, press CTRL+ENTER keys all at once. You should start by selecting the row until where you want your formula to end. The same process applies when you want to apply the same formula to the entire row. This will eventually give you the results. After this, press CTRL+Enter keys together. To do this, use the below steps:įirstly, select the whole column and enter the formula to the first cell ie. There's a better way to use keyboard shortcuts and eventually achieve the same end results. In most of the cases, the column you want to apply the formula to have a couple of cells and using a dragging fill handle may not be very convenient. Now let's see three simple ways of doing this that will save you both time and energy. There are some tricky ways of doing this apart from dragging the formula all along.
When you need to apply the same formula as it is with this case, assume C1=A1*2, C2=A2*2, C3=A3*3……Cn=An*2, there's a simpler way of doing it. Dragging is also a very boring way of doing your job. Although this may bring you an answer, at last, it will consume a lot of your time and energy. Now suppose you have one formula that you want to apply to the entire column easily without having to waste a lot of your time? One of the most common ways of doing this is by dragging the formula from cell1 to the last cell. Suppose now you are computing monthly expenses and profits with your Office calculator? Don't you think this can take a lot of your time? Definitely you will waste an entire day adding numbers and computing manually using the same formula. I can guess that you need an easy and faster way of solving some of these issues without much stress. This Microsoft application also makes it very easy and simple for anybody to compute some problems that would otherwise take a lot of time doing manually. Excel is helping people and businesses solve some of the hardest tasks.