Extending a Range of cells in formulas

I have a datasheet that has numerous calculations associated with it both in the form of a range of cells and an array of cells. This was a protatype and I set these at a maximum of 250 rows.
Is there an easy way to extend the number of rows included in all formula to 2500 otjher than manually amendind each one thats entered?

Regards
Araujo

Hi,

Select all the cells and use Edit Find Replace. Specify find to be 250 and Replace to 2500.

HTH