Forum Discussion
Angie Tabrizi
Jul 12, 2018Copper Contributor
Excel Custom Cell Style
I am creating templates for my office and I want to include 5 custom cell styles for our different fonts (body text, headers, etc). Every time I try to create 5, the one that is alphabetically last ...
- Jul 15, 2018If I create that style *and then apply it to the cell*, save close and reopen the file, the style sticks.
Angie Tabrizi
Jul 13, 2018Copper Contributor
So weird. I did it and called it Style 5, save, close, reopen -- it was there. Just changed the name of that style to Title_WSA, save, close, reopen -- it was gone. This is ridiculous. I want to name it Title_WSA because that is the same name as this style in our Word templates (and there really is no reason why this would keep deleting itself).
When you save it with the name ' Title_WSA ' is it still there after saving and closing?
JKPieterse
Jul 15, 2018Silver Contributor
If I create that style *and then apply it to the cell*, save close and reopen the file, the style sticks.
- Angie TabriziJul 16, 2018Copper Contributor
Thanks!
- JKPieterseJul 16, 2018Silver ContributorI think I would have added a sheet with the custom styles, like I describe here: https://jkp-ads.com/Articles/styles05.asp
- Angie TabriziJul 16, 2018Copper Contributor
Thank you for the help -- this worked for me too. I had wanted all the cells to start in with the body text style, but I just scrolled to the right a ridiculous amount of cells to apply this to one cell that will likely never been seen. Going to call this good enough!