Forum Discussion

midnightodyssey's avatar
midnightodyssey
Copper Contributor
Jun 05, 2024

Keyboard shortcut to collapse formula bar not working

About a week ago the regular keyboard shortcut that I use to collapse and expand the formula bar in Excel (Ctrl+Shift+U) stopped working, and instead increased the worksheet zoom by 5%.

 

Would anyone know why this has changed, or what the updated keyboard shortcut for collapsing/expanding the formula bar would be?

  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 10, 2024

    midnightodyssey 

    If shortcut works in Excel safe mode (not Windows safe mode) that most probably means that one of add-ins uses same shortcut and blocks it for Excel.

    Try to run Excel in normal mode, disable add-ins one by one and each time check if the shortcut works. With that you localize the add-in which prevents using shortcut.

    After that disable using of that shortcut for add-in, if that's possible. If not, when to choose, use add-in but have no shortcut in Excel, or opposite.

    • midnightodyssey's avatar
      midnightodyssey
      Copper Contributor
      I'm using Windows, version 2311. The issue seems to fix itself when starting in safe mode, however I am not able to load specific add-ins that I need in safe mode
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        midnightodyssey 

        If shortcut works in Excel safe mode (not Windows safe mode) that most probably means that one of add-ins uses same shortcut and blocks it for Excel.

        Try to run Excel in normal mode, disable add-ins one by one and each time check if the shortcut works. With that you localize the add-in which prevents using shortcut.

        After that disable using of that shortcut for add-in, if that's possible. If not, when to choose, use add-in but have no shortcut in Excel, or opposite.

Resources