"SteveW" wrote in message
...
On Sat, 18 Mar 2006 15:47:42 -0500, Debra Dalgleish
wrote:

Select cell E2, and enter the formula: =C2/B2
Format the cell as Percent
With cell E2 selected, point to the Fill Handle -- the small black
square at the bottom right of the selection.
When the pointer changes to a small black plus sign, double-click,
to fill the formula down to the first blank row.

dragging 25,000 is a real pain
click on e2
Ctrl+C to copy this cell

Ctrl+End will take you down to the bottom corner
Click on the last cell in E that you want the formula in
Hold Shift
Ctrl+Home will take you back to to the top, use the cursor
to move *top* of this block to e3
Paste in the formula - Ctrl+V

Messy, but after a while that sort of Block selection gets easier,
whereas I never get used to dragging 25,000 lines !

But it is hardly faster than double clicking lower right corner of E2 as
Debra suggested?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon