Thread
:
I have almost 25,000 rows of data and I'm a little scared LOL
View Single Post
#
9
Posted to microsoft.public.excel.newusers
Tushar Mehta
Posts: n/a
I have almost 25,000 rows of data and I'm a little scared LOL
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 ,
says...
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 !
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
Reply With Quote