I lost the ability in the toolbars to see the full function band. I.e
somewhere where I can type in the forumula. Which toolbar or setting allows
this to happen?

Thanks

Try

ViewFormula Bar


--

HTH

Bob

"Jennifer H" wrote in message
...
I lost the ability in the toolbars to see the full function band. I.e
somewhere where I can type in the forumula. Which toolbar or setting
allows
this to happen?

Thanks

Jennifer,

You didn't say which excel version

e2003
Tools|Options - View tab - check 'Show formula bar'

e2007
Office button|Excel options|Advanced|Display group and check 'Show formula
bar'
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Jennifer H" wrote:

I lost the ability in the toolbars to see the full function band. I.e
somewhere where I can type in the forumula. Which toolbar or setting allows
this to happen?

Thanks

Actually Mike, View/Formula Bar works in both 2003 and 2007 , one is a menu,
one is a ribbon tab.

--

HTH

Bob

"Mike H" wrote in message
...
Jennifer,

You didn't say which excel version

e2003
Tools|Options - View tab - check 'Show formula bar'

e2007
Office button|Excel options|Advanced|Display group and check 'Show formula
bar'
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Jennifer H" wrote:

I lost the ability in the toolbars to see the full function band. I.e
somewhere where I can type in the forumula. Which toolbar or setting
allows
this to happen?

Thanks

Bob,,

One day I'll learn to navigate the E2007 Ribbon, I'm getting there, you just
taught me another!! Thanks.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Bob Phillips" wrote:

Actually Mike, View/Formula Bar works in both 2003 and 2007 , one is a menu,
one is a ribbon tab.

--

HTH

Bob

"Mike H" wrote in message
...
Jennifer,

You didn't say which excel version

e2003
Tools|Options - View tab - check 'Show formula bar'

e2007
Office button|Excel options|Advanced|Display group and check 'Show formula
bar'
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Jennifer H" wrote:

I lost the ability in the toolbars to see the full function band. I.e
somewhere where I can type in the forumula. Which toolbar or setting
allows
this to happen?

Thanks


.

But Mike, it is intuitive, MS said so!

--

HTH

Bob

"Mike H" wrote in message
...
Bob,,

One day I'll learn to navigate the E2007 Ribbon, I'm getting there, you
just
taught me another!! Thanks.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Bob Phillips" wrote:

Actually Mike, View/Formula Bar works in both 2003 and 2007 , one is a
menu,
one is a ribbon tab.

--

HTH

Bob

"Mike H" wrote in message
...
Jennifer,

You didn't say which excel version

e2003
Tools|Options - View tab - check 'Show formula bar'

e2007
Office button|Excel options|Advanced|Display group and check 'Show
formula
bar'
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis
that
introduces the fewest assumptions while still sufficiently answering
the
question.


"Jennifer H" wrote:

I lost the ability in the toolbars to see the full function band. I.e
somewhere where I can type in the forumula. Which toolbar or setting
allows
this to happen?

Thanks


.