Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel X for Mac - show formulas

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

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Excel X for Mac - show formulas

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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,574
Default Excel X for Mac - show formulas

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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 256
Default Excel X for Mac - show formulas

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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 762
Default Excel X for Mac - show formulas

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Putting Excel formatting and/or formulas into CSV file Frank D. Nicodem, Jr. Excel Discussion (Misc queries) 1 July 11th 05 10:18 PM
Excel should let me use formulas that refer to other cells w/ form Chenopod Excel Worksheet Functions 7 May 31st 05 04:21 PM
Excel Error when copying formulas Joe Gieder Excel Worksheet Functions 2 March 18th 05 06:01 PM
How can I get EXCEL formulas to work in Works? MJBPPG Excel Worksheet Functions 0 March 12th 05 08:31 PM
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 01:22 AM


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"