Using Drawing Tools in Excel 2007, 2010 and 2013

Excel has drawing tools that you can use like Visio to create flow charts, value stream maps, fishbone diagrams and much more.

For more information, visit the following link:

Many people ask how to use Excel’s drawing tools.

Excel has like a little mini Visio built right into it. So, you don’t really need Visio or anything else exotic to draw most kinds of charts and things. If you click on the insert tab, you’ll see that it allows you to put in pictures and clipart and things of that nature.

But here’s all the various shapes that are available in Microsoft Excel and down here you can see there’s things like flowcharts you can put in call-outs. You can put in arrows, various basic shapes, and connecting devices here and here’s all the things I’ve used most recently.

The easy thing to do here is let’s just go grab from the flow chart we can get a box and just draw it on there and Excel will show you what that box looks like (and you can change the color as needed.)

Then, if you just start typing in there, this is step one, it’ll actually put that in there. If you want to format that object a little bit, you might want to just right-click on the border. There’s lots of tools that come up when you just right-click on a border here.

If you need to change this, all you have to do select on it and click one. Once you’ve got that, you can right click and choose copy and then, say I just want to paste that in here, I could get some more of them in here pretty quick. I can just paste drop various things in here.

Then, with our insert shapes, I might want to connect all of these so I could actually do an elbow arrow connector. I can just take that and draw it down here, from here to there, and then I might need another one of those and so I could actually there, copy or paste this one, or I could just insert another one so we have the ability to insert more of those.

Maybe I want to take this one, and I want this one to run over here and it’ll connect to all that (the little tangential places on here), and then when I move it around, it all stays connected.

This is a very easy way to start to draw little simple charts and things.

Now, one of the things I use is the gridlines to lay everything out, but then once I’m done, we can go over to view and turn off the grid lines on this page, and now we have a nice clean looking page.

If we wanted to, we could put in a decision Diamond and again, we could change the colors on that and just connect all of the dots here.

It’s pretty easy to start to draw whatever kind of diagram you want. Sometimes we have things like charts and maybe I want to make an annotation on this chart, like an insert, and I can choose to insert some sort of box or some sort of text box (I use text boxes a lot). Process is stabled.

So, I might want to put some little special things on a chart. You can actually just stick things right on charts. You can stick them on worksheets and really start to make everything that you produce a lot more readable.

There’s very many kinds of things that you can draw in here: curly lines, square lines, flowcharts, etc.

If I wanted to, I could take and put a call-out on here and simply attach that to a point and say process changed here or something like that.

These are the kinds of things that you can do quickly and easily and then you just redirect things around so that they sit where they’re supposed to sit.

I hope that gives you some ideas about how to start using Microsoft Excel’s drawing tools and again, you’ll see they’re just sitting up here with all the most recently used shapes.

We could just keep drawing easily whatever kind of thing comes into our mind and create that diagram that we’re going to need for various presentations and sometimes I find this is actually even easier than trying to do that in a PowerPoint presentation.

So, enjoy using the tools of Microsoft Excel to draw charts and diagrams and flowcharts and all the stuff that we need to display our ideas and get them across to other people.


Xem thêm bài viết:

Related Post

3 Replies to “Using Drawing Tools in Excel 2007, 2010 and 2013”

  1. if you intend this as a tutorial, then you should actually inform others on HOW TO put all those boxes there… instead of repeating "i can do this" show us HOW? What in the world "let's just go grab this box" mean???? What exactly do you click where when how??? i have no idea if you are clicking away doing right clicks or left or double clicks or dragging??? i have to learn by watching only and then perform smooth at work… it is impossible if you do not say what exactly you are doing… But still somewhat helpful, thank you, i upvote and appreciate at least some help

  2. Hey, I really need help.  Mine doesn't look like that though I'm sure it's the newest version. I gave a insert at the top but it doesn't have shapes. I just want to draw a simple floor plan for a assignment. Can you possibly show me how to do this?

Comments are closed.