On Wednesday 21 September 2005 17:07, Xilin wrote: > In EXCEL, Supoose > A1=1, A2=2, A3=3, ...., An=n, ... > B1=11, B2=22, B3=33, ..., Bn=nn, .. > > I want to input the addition of above A & B into C, i.e.: > C1=A1+B1, C2=A2+B2, C3=A3+B3, .... Cn=An+Bn, .... > > Because columns A & B are very long, if calculate them > one by one will be time consuming. What is the way to > calculate all elements in a single step or batch calculation?
In field C1, enter '=A1+B1' (without the quotes). Now, select field C1, grab the little square handle at the bottom right of the cell, and drag it down the column as far as you need. That'll automatically fill C2 with '=A2+B2', C3 with '=A3+B3' and so on. Alternatively, if columns A + B are too long to bother dragging the box handle thingy all the way down, you should be able to highlight C1, Ctrl+C to copy, click the 'C' column heading to select the entire column, and Ctrl+V to paste... that SHOULD have the desired effect. Cheers Dave P ____ The WDVL Discussion List from WDVL.COM ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: unknown lmsubst tag argument: '' To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
