Re-read Debra's post. There's no dragging involved, just one double-click!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <pc4p12pimd807gr7ad2dsllsdfqtn3hnf2@4ax.com>, sj_w@nothotmail.com
says...
> On Sat, 18 Mar 2006 15:47:42 -0500, Debra Dalgleish
> <dsd@contexturesXSPAM.com> 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 !
>
> >
>
>
> >aaaa wrote:
> >> Firstly I'm a total newb to excel (and access for that matter LOL)
> >> I have almost 25,000 rows of data and I'm a little scared LOL
> >>
> >> its a basic set up, Total, Passed, Rejected ect ect across the top with the
> >> info below.
> >>
> >> example...
> >>
> >> Date Total Passed Rejected
> >> 1/2/05 123 100 23
> >> 1/4/05 324 320 4
> >> 1/6/05 97 96 1
> >>
> >> I need a fifth column showing a percentage of passed.
> >> but I don't know how to do this with out entering the formula 25 thousand
> >> times :-(
> >>
> >> Please help
> >>
> >> Also would really love to be pointed towards an easy to understand
> >> instruction site for access.
> >>
> >> Thank you all,
> >>
> >> Chad
> >>
> >>
>
>