The Paste function will paste everything from the source cell to the destinationn cell including formulas and formats. Using the Paste Special function, you can choose only a certain characteristic from the source cell to the destination cell. For example, you can use the Paste Special command to paste only formats, or only formulas while retaining the original formatting of the destination cell.
For the 60 students, select the entire range of cells where you want to paste and then do the Paste Special. As regards the Precision calculation, I will have to put on my thinking cap and do some investigation. Regards Sameer --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: > 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: <accessindia@accessindia.org.in> > 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: <accessindia@accessindia.org.in> > >> 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 > __________________________________________________ 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
