example in the help topic

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

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 <[email protected]>
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.

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:

> 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 <[email protected]>
> 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.
>
>

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 =

<[email protected]> wrote:

> 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?

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 <[email protected]>
wrote:

>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