Setting Default Attributes for Lines and Arrows

Glenn adds lines and arrows regularly to flowcharts that he creates in Excel. He is wondering if there is a way to set a default line weight, color, and arrowhead, as it gets tedious to change the attributes all the time.

Setting defaults for AutoShapes (such as lines and arrows) is quite easy in Excel. Just follow these steps:

1. Draw your line or arrow as you normally would.
2. Format the line or arrow so that it appears just as you want it to.
3. Right-click on the line or arrow. Excel displays a Context menu.
4. From the Context menu select the option that sets the shape settings as default. Depending on your version of Excel, this option will be named something like Set AutoShape Defaults or Set Default Line.

That's it. For the rest of your current Excel session your lines and arrows will be drawn using your desired formats.