Avatar of easycapital
easycapital
Flag for Macao asked on

Show only custom cell styles in the ribbon (excel 2010).

Dear suppport,

I have added customer cell selection in the ribbon.
When I open new excel files or obtain from others a file - I see the custom cell styles shown in attached "PIC1".
I have my own - see attached .xlsx. I can save them in the XLStart folder or another location you suggest. Or a macro etc.
Please advise how to easily only show my cell styles when I am going to work in someone else file. Do I have to load my own cell styles into their file or can I have them showing up in my PC?
If so, how to approach it.

I would prefer not to affect their cell style list, in their workbook. But if I have to, I was thinking:
1. Macro to delete all cells styles (form PIC1 not being used in a specific file), then I can manually "merge" my cell styles into that affect file, by bringing them from my own file.


Please advise.

Br,Cell-styles.xlsx
JPPIC1.png
VBAMicrosoft ExcelPCMicrosoft Office

Avatar of undefined
Last Comment
Skylar

8/22/2022 - Mon
Skylar

you can open both the file you have your cell styles and the one that you want to paste the style to.

then click on merge style and then from the box as shown in the screenshot you can copy styles from one workbook to another.

w.jpg
easycapital

ASKER
Dear Skylar,
As you show in your picture, the file has many formats. I only want to bring in my formats and not use the ones in the file to merge into.
ASKER CERTIFIED SOLUTION
Skylar

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61