Forum Discussion

sep23's avatar
sep23
Copper Contributor
Nov 04, 2021

Excel Styles Pane - How to dock or keep open

Hello.

In Excel 365 is there a way to dock or keep open the cell styles pane like what used to be possible in prior versions of Excel?  I have to believe there is some way to do this.  Thanks!

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Nov 05, 2021

    sep23 

    If you don't mind a bit of VBA code, this code adds the styles drop-down to your add-ins tab:

     

    
Sub AddStylesBoxToAddInsTab()
    Dim oCb As CommandBar
    Dim cControl As CommandBarControl
    On Error Resume Next
    Application.CommandBars("Temp").Delete
    Set oCb = Application.CommandBars("Temp")
    Set oCb = Application.CommandBars.Add("Temp", , True, True)
    Set cControl = oCb.Controls.Add(ID:=1732)
    oCb.Visible = True
End Sub

     

    The code needs to be run each time Excel starts.

     

    • Jimbo10's avatar
      Jimbo10
      Copper Contributor
      May 23, 2022
      I love Excel and yet find various irritations growing as 'they' add features without fixing - or sometimes deprecating - old ones. This is anothe example.
      Styles attached to Themes is great to save time - BUT can quickly devolve into chaos - and without the convenience of a fixed window how is a user meant to control it? e.g. my current theme has 100 useless shade variations - and each one needs deleting ONE BY ONE!
      Then (like Word) styles seem to accumulate from manual formatting or something and there isn't a simple tool to prevent or fix this either. Luckily there are good people with VBA skills!
      (Especially frustrating when e.g. formatting pop-outs for features like charts is available, i.e. it's not as if this feature would be outside the Excel design language.)
      I would like to think MS is taking these comments into account but I'm not even sure what forum I'm on...

Resources