Excel on Mac -- Where is formula bar?

[The Hun]

My friend has a Mac is now learning Excel. She has toolbars Standard
and Formatting checked.

The formula bar is missing from up in the menu of the toolbar
functions.

Can someone tell us how to get the formula box to appear in its usual
place up in the toolbar menu? She has the Fx button, which makes the
formula bar appear when clicked, but it disappears when she clicks
"cancel."

On a Mac, how do you get the formula bar to display and remain
displaying?

Thanks,

 

[Sandy Mann]

I thought that one of the Mac users would have answered. I have never used
a Mac but assuming that it is not too different to PC's try:

Tools > Options > View and put a check "Formula bar"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[The Hun]

I thought that one of the Mac users would have answered. I have never used
a Mac but assuming that it is not too different to PC's try:

Tools > Options > View and put a check "Formula bar"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

Oops! There isn't an "Option" choice under Tools. However, there was
"Formular Bar" under View. she got it. Thanks.

 

[Sandy Mann]

There is in PC's as well but your mention of your friend having the Standard
and Formatting toolbars checked lead me you believe that the Mac did not
have the option there. Still, I'm glad that you got it yourself - who need
these Mac users help! <g>

--
Regards,

Sandy

In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk