In MS Excel, Text Box borders

In MS Excel, what has to happen for Text Box borders to go from dash to solid? I'm using, "No Outline and No Fill", but that seems not to matter. Every Text Box I build starts with a dashed outline. If I manipulate ten of them, some number wind up dashed and some solid. I've ran tests and can't make the dashed stay. This is not an earth shattering difference, I understand,  but I will be asking someone else to work with this form and I need it to make sense and be consistent. I favor the dashed outline.


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tj aCommented:
Try clicking on any cell that has the preferred dashed lines, then on the Home tab, double-click "Format Painter" then click the other cells that you'd like to format.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Justin AlvarezAccount ManagerCommented:
With a text box, you can right click on the border to bring up some options. Depending on which year of Excel you have you should be able to modify the outline. Here's what it looks like in Excel 2013

Let us know if that helps.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.