Forum Discussion
Excel Custom Cell Style
- Jul 15, 2018If I create that style *and then apply it to the cell*, save close and reopen the file, the style sticks.
I could add the style (based on the formatted cell without a problem, I called it "Style 5" and it sticked around after a save, close and re-open of the file.
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?
- JKPieterseJul 15, 2018Silver ContributorIf 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
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!
- 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