Re: MS Excel: Formula for calculation in entire column
Quote:
|
Originally Posted by Tech.Masti
oh ya it surely possible, but i cant remember the formula correctly just now, do the following .....
in C1 cell write =(A1-B1) and press ENTER this should work on cell C1 . then in take your mouse pointer in right-down corner of the C1 cell, and you will found a + sign, click it and drag down upto C40 cell..... i last use EXCEL 2 years ago, but i am quite sure this will work, HERE also have a another process by which you will do it from menu, cant remember it just now....  reply if it work.... |
Thanks a lot.  U'r solution worked like charm for me. 
__________________
Dell Studio 1558, Intel i5 M430 @ 2.27 Ghz, 4 GB RAM, 1 GB ATI 5470 Mobility, 500 GB HDD, IDT HD Audio with Creative X-Fi MB software
|