How to Set Default Attributes for Lines & Arrows in your Worksheets

If you adds lines and arrows all the time to flowcharts that you creates in Excel, you may be wondering if there is a way to set a default line weight, color, and arrowhead. Turns out there  is!

Follow the steps below:

  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 your line or arrow to display the Context menu.
  4. From the Context menu select Set Default Line.

Now,  your lines and arrows will be drawn using the formats you made the default for the rest of your current worksheet!