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!

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

Leave a Reply

Your email address will not be published. Required fields are marked *