Excel X for Mac - show formulas

J

Jim Carlton JMS

Is it possible to show formulas on a worksheet in Excel x for mac? I know
how to do this on a pc, but I can not seem to find a way on this mac. I am a
teacher in middle school and I want to give a problem that the students can
solve and then print their answers in both values and formulas.

HELP!!

Jim Carlton
[email protected]
 
D

Dave F

Well one possibility is to create a UDF called get formula:

Function GetFormula(Cell As Range) As String
GetFormula = Cell.Formula
If Cell.HasArray Then GetFormula = "{" & GetFormula & "}"
End Function

If there is a formula in cell A1, =getformula(A1) will show it.

But I'm not sure that this is what you're looking for. Another way to show
formulas is to put an apostrophe to the left of the = sign, but then the
formula itself doesn't calculate because XL considers that text.

Dave
 
D

Domenic

Try...

Excel > Prefereces > View > and check Formulas

or

CONTROL+ `

Note that the ` key can be found next to the 1 key.

Hope this helps!
 
M

Mike Middleton

Jim -

Excel | Preferences | View | (Window Options) Formulas

Or, on modern Mac (and Windows) keyboards, Ctrl + ~ (i.e., hold down the
control key and press the tilde key in the top left of the keyboard)
toggles formula view on and off.

- Mike
http://www.mikemiddleton.com
 
Top