Forum Discussion

DonM9049mentions's avatar
DonM9049mentions
Copper Contributor
Jan 23, 2025

All of a sudden Excel not highlighting selected worksheets

Historically, when selecting multiple worksheets in excel, the selected worksheets would be highlighted with green underline. Now, the selected worksheets are no longer highlighted. This makes it difficult to identify the selected worksheets. Appreciate thoughts on how to resolve.

  • m_tarler's avatar
    m_tarler
    Jan 23, 2025

    I don't know if it ever changed but here is a visual:

    Sheet1 is ACTIVE ->notice white background, bold lettering and green underline

    Sheet2 &Sheet3 are SELECTED -> notice 'white'/highlighted background and bold lettering (note that Sheet3 is set to the same color as Sheet6 so it is significantly highlighted

    Sheet4-6 are NOT selected -> NOT bold lettering or highlighted.  note that Sheet5 is set to White color

     

    So I suppose one option is to make all tabs a dark color and then the 'highlighting' will stand out better but at the very least do NOT set the tabs to white because that will make it harder to see.

  • Only the active sheet has a green underline. All selected sheets have a white tab color.

    As far as I know this hasn't changed.

    • m_tarler's avatar
      m_tarler
      Bronze Contributor

      I don't know if it ever changed but here is a visual:

      Sheet1 is ACTIVE ->notice white background, bold lettering and green underline

      Sheet2 &Sheet3 are SELECTED -> notice 'white'/highlighted background and bold lettering (note that Sheet3 is set to the same color as Sheet6 so it is significantly highlighted

      Sheet4-6 are NOT selected -> NOT bold lettering or highlighted.  note that Sheet5 is set to White color

       

      So I suppose one option is to make all tabs a dark color and then the 'highlighting' will stand out better but at the very least do NOT set the tabs to white because that will make it harder to see.

Resources