How To – Default Excel Attributes for Lines/Arrows

I have a subscriber who regularly adds lines and arrows 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!

Exit mobile version


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!