+ Reply to Thread
Results 1 to 5 of 5

example in the help topic

  1. #1
    Lois Ann
    Guest

    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

  2. #2
    Gord Dibben
    Guest

    Re: example in the help topic

    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@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.



  3. #3
    Lois Ann
    Guest

    Re: example in the help topic

    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 <LoisAnn@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.

    >
    >


  4. #4
    SteveW
    Guest

    Re: example in the help topic

    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@discussions.microsoft.com> 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?


  5. #5
    Gord Dibben
    Guest

    Re: example in the help topic

    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@discussions.microsoft.com>
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1