01-09-2009, 04:59 PM
|
|
Registered User
|
|
Join Date: 30 Dec 2008
Location: Vermont, USA
MS Office Version:Excel 2003
Posts: 64
|
|
Hi-
you can extend the formulas as far as you want (make sure to do both columns A:D and F:N-- this will be two separate fill-downs-- although if you don't yet have the addresses in column E, you could highlight A:N and do it all at once).
To fill down, highlight the last row of formulas (currently 68 or so), i.e. highlight A68:D68, go to the lower right corner of this highlighted portion and hover over that corner until the cursor turns into a little black + sign. Then click and drag down as far as you want.
I wouldn't suggest that you do fill down much further than row 1000 or so because some of the formulas are very complex and therefore very memory intensive. Your processor will slow WAY down. I would also suggest that you switch to manual calculation if you're going to do anywhere near that many. To switch to manual formula calculation, go to the Tools menu--> Options --> Calculation tab --> Manual calculation --> untick the "recalculate on save" box --> OK. Now the formulas will not do anything unless you press F9 on your keyboard. Believe me, you do not want that many formulas recalculating themselves more times than necessary or it will take forever to do anything. Again, save an extra copy of this in case something happens to the first-- you can delete all the formulas below row 3 in this copy if you want to make it a smaller file size.
You can email me at jjeerreemmyy@gmail.com if you have questions.
|