Ho Do You Define Custom Shape Styles

I don't like any of the standard styles for shapes, particularly text-boxes and I have to set them manually every time. How do I store preset shape styles, as you can for cells?

Have you considered setting up the Text Box then right clicking it and clicking on:-

Set as Default Text Box

You could also set up a macro for this and save it to the Personal Macro Workbook.

Thank you for that suggestion. I do use the default option but it still only gives me the one preset style, so to speak. I have steered clear of macros in the last several years but I may give that a look.

Thank you Dihao for confirming my fears. I will post the suggestion. I suspect it is a considerable undertaking to provide this utility but then they haven't had to do much in the last few years except collect our subscriptions. :)

Sean

Hi Karnada,

Thank you for posting your question in this community.

If I am understanding correctly, you would like to save your custom shape style or Text boxes in Excel so that you don’t have to readjust the color, effect, size every time since you frequently use them in Excel.

In this scenario, I am afraid it is not feasible with the built-in features of Excel app at this moment. Every time when we insert a shape or Text box we need to manually change its settings or apply the built-in styles under Shape styles. In this case, I suggest you can raise this idea in Excel UserVoice platform, which it can let the related product team be aware of this scenario and improve it with a better solution. Sorry for the inconvenience caused.

However, here is a workaround you may consider, which you can create an Excel file like a template library to store all your frequent used shapes or text boxes you created. Then you can copy and paste the shape or text boxes you costumed based on your demand.

Best regards,

Dihao