N/APosted on - 01/14/2012
I am looking for some input regarding this matter in Excel 2003. My spreadsheet has the same formula in all cell of a particular column by the use of row and indirect functions. It is using almost six thousand rows. Presently, I have to copy the formula to each cell. I think this is increasing the calculation processing time of Excel. Will it possible to assign a formula for a given column? By this I can give one formula for whole columns and this can reduce the calculation time. Please help me.
How can I assign a formula for the whole column?
If the formula that you are using spans the cells of the column all the way down, then you will not need to copy the formula one by one in each cell all the way down. There is an easier way that you can use to do that, which is the following:
You will just need to specify the formula that you want in the top cell of that column.
Check and make sure that it gives the desired result.
After you have done that, you will click on that cell.
And then move the cursor to the bottom right corner of the cell.
You will see the cursor change into a plus (+) sign.
Right click and hold down the cursor.
And then drag it all the way down to the last cell that you want the formula to appear in that column.