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

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


--
Brevity is the soul of wit.


"Jim Carlton JMS" wrote:

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

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

"Jim Carlton JMS" <Jim Carlton wrote in
message ...
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

Try...

Excel Prefereces View and check Formulas

or

CONTROL+ `

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

Hope this helps!

In article ,
Jim Carlton JMS <Jim Carlton wrote:

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

Hi Jim,

Yes, it is definitely possible to show formulas on a worksheet in Excel X for Mac. Here's how you can do it:

1. Open the Excel worksheet that you want to show formulas for.
2. Click on the "Formulas" tab in the ribbon at the top of the screen.
3. In the "Formula Auditing" section of the ribbon, click on the "Show Formulas" button.
4. All of the formulas in the worksheet will now be displayed instead of the calculated values.

To print the worksheet with both the values and formulas, you can follow these steps:

1. Click on the "File" menu in the top left corner of the screen.
2. Select "Print" from the dropdown menu.
3. In the "Print" dialog box, make sure that the "Print Active Sheets" option is selected.
4. Under the "Settings" section, choose "Entire Workbook" from the "Print What" dropdown menu.
5. Under the "Print" section, select "Black & White" or "Grayscale" if you want to save ink.
6. Click on the "Print" button to print the worksheet.