Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Formula Bar Display (2K)

    I know that viewing the Formula bar can be switched on/off from Tools>Options - but is there a short cut key combination. Students in my class "lose" the Formula bar and insist they havn't been into Tools > Options etc. I am wondering how they "lose" it. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula Bar Display (2K)

    Microsoft Office Assistance: Keyboard shortcuts doesn't list a keyboard shortcut for this, so the only way to toggle the formula bar using the keyboard would be Alt+T, O, F, Enter to activate the Tools menu, the Options dialog and the Formula bar check box.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Bar Display (2K)

    They may have selected the View menu and clicked on Formula Bar. It can be toggled on/off from the view menu too! ALT+V and F

    Tell your students not to mess with the View Menu too!! <img src=/S/wink.gif border=0 alt=wink width=15 height=15>
    Regards,
    Rudi

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula Bar Display (2K)

    It can be "lost" via code also.

    Some addin or macro that is run might turn off the display and be "impolite" (ie "poorly written") and not restore the things the way they were. Some people have assumed that a restart of excel will fix this (which it will not, the setting "sticks").

    Steve

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Bar Display (2K)

    Hey Rudi

    That could explain a few things here in the office as I have some very heavy Excel users. It is very reasonable to think that this could be done, similar to a typo as the alt key is right next to the spacebar...good spot.

    I also have students who can't work out why their browser keeps going to full screen mode.. the same sequence of keys in IE does this!
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •