Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE
SOLVED

Problem with displaying styles in excel

Copper Contributor

I lost the constant display of styles, now I always have to click on the button to see them.

the way I see it now

Sergey_SN_0-1695459508110.png

but I need to see it like this

Sergey_SN_1-1695459547216.png

how i can fix this? it looks like the partition is collapsed, but I can't unwrap it.

 

help me please

9 Replies

@Sergey_SN 

Does it help if you make the workbook window wider?

Sergey_SN_0-1695475525792.png

No, there is a free space on the right side, but if i change the language in the program, everything is shown correctly (but when i back, i have trouble again)

@Hans Vogelaar 

@Sergey_SN 

You can report the problem from within Excel: select File > Send a Frown (or the equivalent in your language, of course)

all my exel files has this problem) i dont understand whats happened
@Hans Vogelaar 

best response confirmed by Sergey_SN (Copper Contributor)
Solution

@Sergey_SN 

Home tab is overloaded and in Russian icon names are much wider compare to English. Expanded cell styles requires lot of space which is not enough in Russian version.

Above is just my guess after I played with both. 

Sergey_SN_0-1695479812490.png

Thank you so much for your reply, that solved my problem!

 

some time after installation, excel adds the add-in section to the shortcut bar (not immediately) and this makes the styles window become a button

@Sergei Baklan 

@Sergey_SN 

As workaround you may create new tab and new group on ribbon, add to it Cell Styles, don't forget to untick Minimize Gallery from the right click menu on Cell Styles here

image.png

Result will be like

image.png

Doing above you may give any names to new tab/group and place it on ribbon on most suitable for you place. Since this group will be relatively empty you may add other icons to work with cells to keep them in one place. Depends on what do you use more often.

This is a good idea, thank you for this solution)

@Sergei Baklan 

@Sergey_SN , you are welcome

1 best response

Accepted Solutions
best response confirmed by Sergey_SN (Copper Contributor)
Solution

@Sergey_SN 

Home tab is overloaded and in Russian icon names are much wider compare to English. Expanded cell styles requires lot of space which is not enough in Russian version.

Above is just my guess after I played with both. 

View solution in original post