We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Make a Phone Tree Using Microsoft Excel

Updated February 21, 2017

Phone trees are a way to reach large numbers of people quickly. It works like a pyramid scheme; if an emergency or other time-sensitive event occurs, the person at the top of the tree calls the people below them and those people call the people below them. Within a short period of time, thousands of people can be reached and informed about the event. Microsoft Excel has a built in Smart Art feature than can create a telephone tree in minutes.

Loading ...
  1. Click "Insert" and then click "Smart Art" from the illustrations group.

  2. Click "Hierarchy" and then click "Organizational chart."

  3. Click "OK" to insert the graphic into your spreadsheet.

  4. Click on the top box and then type the name and phone number for the person at the top of the tree. Click "x" at the top right when you are finished typing.

  5. Complete the rest if the tree by clicking on each box and then filling in names and phone numbers.

  6. Tip

    To add more shapes to your phone tree, right click where you want to add another shape and then click "Add Shape." Click one of the choices presented. For example, click "Add shape before."

Loading ...

About the Author

Stephanie Ellen teaches mathematics and statistics at the university and college level. She coauthored a statistics textbook published by Houghton-Mifflin. She has been writing professionally since 2008. Ellen holds a Bachelor of Science in health science from State University New York, a master's degree in math education from Jacksonville University and a Master of Arts in creative writing from National University.

Loading ...