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() funtions). 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.
MS Excel 2003
February 8, 2011 4:54 PM
August 18, 2011 6:50 PM