Add Pizzaz To Arrows And Pointers In Excel Spreadsheets


When I do a presentation that includes spreadsheets, I usually use arrows to illustrate the relationship between numbers, and while it works OK, it lacks pizazz. Is there some way I can add more impact to my spreadsheets?

There are lots of things you can do—such as adding color, size and shape. Let’s look at the options. If you’re using Excel 2007, click on Insert and then on Shapes, which produces this menu:

Once you click on a shape, the Home Ribbon switches to Format and, depending on which shape you select, that menu automatically adjusts to the special options for your selection (see screenshot below).

Not only do you have many choices, but each shape is easily adjustable, for example, by grabbing its edge with your cursor and reshaping it, say, from…

this... this.

In Excel 2003, however, you have fewer options and the customization steps are not as convenient. Begin by clicking on View, Toolbars, Drawing and then go to the bottom of the screen and either click on the simple arrow in the toolbar or click on AutoShapes, and then Lines if you want still more choices…

…or Block Arrows if you want an arrow that you can make a bit fancier…

and click on your selection. Now move your cursor to where you want it to appear in the worksheet and click. If you choose Block Arrows, you can customize some of the choices by clicking and dragging, for example:

from this... this.

Now, to gussy it up further, go to the toolbar on the top of the screen and click on Format, AutoShape and this screen will appear:

Make sure the Colors and Lines tab is selected, and now you can customize both the arrow line and arrowhead. You also can choose whether and how much you want the arrow image to be transparent so the data below can show through.


Preparing the statement of cash flows

This instructive white paper outlines common pitfalls in the preparation of the statement of cash flows, resources to minimize these risks, and four critical skills your staff will need as you approach necessary changes to the process.


Keeping you informed and prepared amid the coronavirus crisis

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.