example in the help topic Lois Ann 01.08.2006 22:12:01 I put in a wrong formula and then I went to the function help and it said to open a blank worksheet, Select the example in the Help topic. I can't find the example in the help topic. Do I open a blank worksheet and then press CTRL +C to opent the examples? I was in the ATAN function. -- Lois Ann

Re: example in the help topic Gord Dibben <gorddibbATshawDOTca> 01.08.2006 22:35:27 On main menu select Help and type in ATAN to bring up help screen. There are three examples shown in the Help for ATAN =ATAN(1) =ATAN(1)*180/PI() =DEGREES(ATAN(1)) Select one of them(or more) and CTRL + C to copy. Insert>Insert Worksheet Select A1 and CTRL + V to paste. Gord Dibben MS Excel MVP On Tue, 1 Aug 2006 15:12:01 -0700, Lois Ann <LoisAnn[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I put in a wrong formula and then I went to the function help and it said to >open a blank worksheet, Select the example in the Help topic. I can't find >the example in the help topic. Do I open a blank worksheet and then press >CTRL +C to opent the examples? I was in the ATAN function.

Re: example in the help topic Lois Ann 01.08.2006 22:57:01 Well I had that on the screeen, but I don't know how to select one, when I tried to click on one, it just showed the same as what was on the text. I thought it would bring up an example of a problem? -- Lois Ann "Gord Dibben" wrote: [Quoted Text] > On main menu select Help and type in ATAN to bring up help screen. > > There are three examples shown in the Help for ATAN > > =ATAN(1) > =ATAN(1)*180/PI() > =DEGREES(ATAN(1)) > > Select one of them(or more) and CTRL + C to copy. > > Insert>Insert Worksheet > > Select A1 and CTRL + V to paste. > > > Gord Dibben MS Excel MVP > > On Tue, 1 Aug 2006 15:12:01 -0700, Lois Ann <LoisAnn[ at ]discussions.microsoft.com> > wrote: > > >I put in a wrong formula and then I went to the function help and it said to > >open a blank worksheet, Select the example in the Help topic. I can't find > >the example in the help topic. Do I open a blank worksheet and then press > >CTRL +C to opent the examples? I was in the ATAN function. > >

Re: example in the help topic Gord Dibben <gorddibbATshawDOTca> 01.08.2006 23:15:51 To select an example from the help screen, just slowly drag the mouse pointer across the formula to highlight it then CTRL + C to copy. The example is the formula and shows the result of that formula. Not very helpful in most cases<g> Gord On Tue, 1 Aug 2006 15:57:01 -0700, Lois Ann <LoisAnn[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Well I had that on the screeen, but I don't know how to select one, when I >tried to click on one, it just showed the same as what was on the text. I >thought it would bring up an example of a problem? Gord Dibben MS Excel MVP

Re: example in the help topic SteveW <sj_walton[ at ]nothotmail.com> 01.08.2006 23:16:03 Not alot of actual code to copy on those help pages. But in general Click and select the text you want use Then Ctrl+C The help text should clarify the atan stuff though. Steve On Tue, 01 Aug 2006 23:57:01 +0100, Lois Ann = <LoisAnn[ at ]discussions.microsoft.com> wrote: [Quoted Text] > Well I had that on the screeen, but I don't know how to select one, wh= en = > I > tried to click on one, it just showed the same as what was on the text= .. I > thought it would bring up an example of a problem?