I am using MS Excel 2003. I have a spreadsheet with the exactly the same formula in every cell of a given column (This is possible by using the row() and the indirect() functions). The spreadsheet is using 6000 rows. Currently, I have copied the formula into each cell. This increases the calculation time of the spreadsheet.
Is it possible to designate a formula for a given column? If so, this would mean I would have only one formula for the whole column and possible speed up the calculation time.