Excel: Hide FX toolbar

[vivasuzi]

Hi,

Is it possible to Hide the toolbar that has the Cell number and the FX box in it? It is irritating when I have cells with a lot of data b/c the FX bar will expand to show all the data. I don't want it to expand at all. Can I hide this bar completely?

Thanks!

*Suzanne*

http://www.vivasuzi.com

 

[xlbo]

Tools>Options>View

uncheck "Formula bar"

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[vivasuzi]

Thanks! wonder why it isn't just in the list of toolbars to turn off!

*Suzanne*

http://www.vivasuzi.com

 

[xlbo]

It's not a toolbar - it is a visual option like scroll bars & worksheet tabs...

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[vivasuzi]

I understand that but it looks like a toolbar, and acts like a toolbar, so it should just be a toolbar.

*Suzanne*

http://www.vivasuzi.com

 

[xlbo]

Doesn't look like a toolbar to me - doesn't have any dropdowns, doesn't have any menus.......Looks like a formula bar if you ask me...

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[GlennUK]

Nah, looks like a toolbar ... dropdown for defined names, buttons to click while you are editing .... but no menus, I'll give you that .

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlbo]

All toolbars are dockable - this one is fixed position - just visible or not. To me, it is more like scroll bars - a visual aid if you want / need it - very different from a toolbar

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[KenWright]

It's never looked like anything I would want to turn off, so I don't care either way, I'm keeping it

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[xlbo]

LOL

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question