Office 2016

How To Set Default Attributes for Lines & Arrows in Excel

I have a subscriber who adds lines and arrows regularly to flowcharts that she has created in Excel. She inquired whether there is a way to set a default line weight, color, and arrow, because it is very tiresome  changing the attributes all the time. As it turns out, it really is not all that difficult to do.

Follow the steps below to learn how:

  1. Draw your line or arrow as you would normally.
  2. Format your line or arrow so that it appears exactly the way you want it.
  3. Right-click on your line or arrow to display a Context menu.
  4. From the Context menu select Set Default Line.

It doesn’t get much easier than this!