example in the help topic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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?
Click to expand...

Gord Dibben MS Excel MVP
 
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
 
Back
Top