Toolbar question
in [Functions]
|
Prev: IF or VLOOKUP
Next: Using DCOUNT
From: Jennifer H on 26 Mar 2010 10:48 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
From: Bob Phillips on 26 Mar 2010 10:50 Try View>Formula Bar -- HTH Bob "Jennifer H" <JenniferH(a)discussions.microsoft.com> wrote in message news:B8245629-0869-4C00-AC0F-5A8FD4CED6AE(a)microsoft.com... >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
From: Mike H on 26 Mar 2010 10:58 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
From: Bob Phillips on 26 Mar 2010 11:12 Actually Mike, View/Formula Bar works in both 2003 and 2007 , one is a menu, one is a ribbon tab. -- HTH Bob "Mike H" <MikeH(a)discussions.microsoft.com> wrote in message news:D947C2A7-0176-44D0-A1DE-8D31B43EA118(a)microsoft.com... > 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
From: Mike H on 26 Mar 2010 17:05
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" <MikeH(a)discussions.microsoft.com> wrote in message > news:D947C2A7-0176-44D0-A1DE-8D31B43EA118(a)microsoft.com... > > 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 > > > . > |