Dear Vikas, If you want to copy a formula from a cell to a range of cells, do the following: 1. Be in the cell, whose formula you want to copy and press control + c. 2. To select the range of cells, where you want to copy, be in the north west corner and pressing shift and right arrow or down arrow, go to the south east corner and release the keys. 3. do control + v and your job is done. 4. please note that when you copy a formula, the input cells will change. For example, if you copy a1+b1 ,which you had defined in c1, when you copy from c2 to c10, the input cells will also change as a2+b2 and a10+b10. If you want a particular cell address not to change, put $ in the formula. For example, if you say $a1 and copy from b1 to n1, the cell address will not change, If you put a$1, then, when you copy from c2 to c10, the cell address will not change. If you put $a$1, the cell address will never change, where ever you copy. I hope this will help you. regards
----- Original Message ----- From: "Vikas Kapoor" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, July 09, 2006 12:30 AM Subject: Re: [AI] EXCEL QUERY > Thanks Sameer once again but this didn't solve the problem this time. By > doing this, it is pasting only in the cell where I'm standing, it is not > dragging for all 60 students. That simply means each time I have to repeat > my action. If this be the case, then what is the difference between paste > and paste special? Another thing that I would like to ask is that when I > convert to 2 decibels, my result comes .1% less than the actual result. > However, when in the option, in the calculation tab, I check the box, > which > says "precision as displayed", then the accurate result comes but before I > press the ok button after clearing that box, it says, "all data will > permanently lose accuracy!". What does that mean? In my case, instead of > losing, it is giving me more precise accuracy, ha ha ha! > Regards, > Vikas Kapoor, > MSN ID: > [EMAIL PROTECTED] > Yahoo ID: > [EMAIL PROTECTED] > Skype ID: dl_vikas > Mobile: (+91) 9891098137. > ----- Original Message ----- > From: "sameer latey" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Saturday, July 08, 2006 10:31 PM > Subject: Re: [AI] EXCEL QUERY > > >> >> Try the following to copy and paste the same formula >> in multiple cells. >> >> 1. Place your focus on the cell from which you want to >> copy the formula and the number formats. >> 2. Press Ctrl+C to copy. >> 3. Select the cells in which you want to paste. >> 4. Go to Edit on the Menu Bar and arrow down to Paste >> Special. Press enter on the Paste Special option. >> 5. A dialog box will open containing a series of radio >> buttons. Arrow down through the radio buttons till you >> come to the button titled "Formulas and Number >> Formats". >> 6. Select the Formulas and Number Formats radio button >> and press OK. >> >> This should paste the formula and the number format of >> 2 decimal places in all the destination cells. >> >> Regards >> Sameer >> --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: >> >>> Thanks a lot, Ajay and Sameer for such a prompt >>> response. My problem is now >>> completely solved. One more thing please, if we have >>> to copy the same >>> formula for every student, we generally do by copy >>> and paste command, while >>> the sighted people would do just at a click of a >>> mouse button for all the >>> students, no matter hundreds of them, is there any >>> way through jaws to drag >>> the same way as it is done by mouse? >>> Regards, >>> Vikas Kapoor, >>> MSN ID: >>> [EMAIL PROTECTED] >>> Yahoo ID: >>> [EMAIL PROTECTED] >>> Skype ID: dl_vikas >>> Mobile: (+91) 9891098137. >>> ----- Original Message ----- >>> From: "ajay sharma" <[EMAIL PROTECTED]> >>> To: <[email protected]> >>> Sent: Saturday, July 08, 2006 5:38 PM >>> Subject: Re: [AI] EXCEL QUERY >>> >>> >>> > hi vikas myself ajay sharma from blind relief >>> association, delhi >>> > >>> > select the cells in which u have entered the >>> formula and then go to format >>> > menu. in format menu choose cells... then choose >>> number tab by pressing >>> > control plus tab. in number tab press tab once >>> then your cursor goes to >>> > category list. in category list select number by >>> pressing down arrow. >>> > after >>> > selecting number press tab it will jump to the >>> decimal places, choose 2 >>> > from >>> > that spin box and click on ok.your problem will be >>> solved. >>> > >>> > Regards >>> > Ajay Sharma >>> > >>> > >>> > >>> > On 7/8/06, Vikas Kapoor <[EMAIL PROTECTED]> >>> wrote: >>> >> >>> >> Dear Members, >>> >> I know here on this list there are many excel >>> specialists. Though I don't >>> >> have any mastery over excel, I use this >>> application for a very limited >>> >> purposes like preparing the internal assessment >>> for my college students >>> >> and >>> >> I find it very useful for this purpose. I just >>> wanted to know one very >>> >> minute clarification, that is, how do we restrict >>> the formula results to >>> >> only two digits after dot. Suppose, after some >>> calculations, if the >>> >> result >>> >> displayed is, 75.318654, how can we restrict to >>> only two digits, that is, >>> >> 75.32. My sighted friends do this just at a click >>> of one mouse command, >>> >> but when I try to access the same with the jaws, >>> or pc cursor, it is not >>> >> visible. >>> >> Regards, >>> >> Vikas Kapoor, >>> >> MSN ID: >>> >> [EMAIL PROTECTED] >>> >> Yahoo ID: >>> >> [EMAIL PROTECTED] >>> >> Skype ID: dl_vikas >>> >> Mobile: (+91) 9891098137. >>> >> To unsubscribe send a message to >>> >> [EMAIL PROTECTED] the >>> subject unsubscribe. >>> >> >>> >> To change your subscription to digest mode or >>> make any other changes, >>> >> please visit the list home page at >>> >> >>> >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >> >>> > >>> > >>> > >>> > -- >>> > Ajay Sharma >>> > Delhi >>> > 9899326670 >>> > To unsubscribe send a message to >>> [EMAIL PROTECTED] >>> > with the subject unsubscribe. >>> > >>> > To change your subscription to digest mode or make >>> any other changes, >>> > please visit the list home page at >>> > >>> >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> >>> To unsubscribe send a message to >>> [EMAIL PROTECTED] with the >>> subject unsubscribe. >>> >>> To change your subscription to digest mode or make >>> any other changes, please visit the list home page >>> at >>> >>> >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >> >> >> __________________________________________________ >> Do You Yahoo!? >> Tired of spam? Yahoo! Mail has the best spam protection around >> http://mail.yahoo.com >> >> To unsubscribe send a message to [EMAIL PROTECTED] >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please visit the list home page at >> >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > To unsubscribe send a message to [EMAIL PROTECTED] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, > please visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > --------------------------------------------------------------------------------------------------------------------- This e-mail contains privileged information or information belonging to IDBI Ltd. and is intended solely for the addressee/s. Access to this email by anyone else is unauthorized. Any copying (whole or partial) or further distribution beyond the original recipient is not intended, and may be unlawful. The recipient acknowledges that IDBI Ltd. is unable to exercise control or ensure or guarantee the integrity of the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and are not binding on IDBI Ltd. E-mails are susceptible to alteration and their integrity cannot be guaranteed. IDBI Ltd. does not accept any liability for damages caused on account of this e-mail. If you have received this email in error, please contact the sender and delete the material from your computer. --------------------------------------------------------------------------------------------------------------------- To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
