Excel can hold a flowchart, but it is not the natural tool for one

You can draw a flowchart in Excel using the Shapes menu and connector lines, but Excel treats it as a drawing layered over a spreadsheet rather than as a native flowchart object. The shapes stay where you place them; they do not snap to a grid or auto-align the way they do in dedicated diagramming software. If you need a flowchart that you will edit often, or one that needs to scale cleanly, a tool like Lucidchart, Miro, or even Google Drawings will give you faster results and cleaner output. But if you already have the data in Excel and want to add a straightforward visual flow without switching programs, the process is straightforward.

A flowchart in Excel works best for straightforward, linear processes with fewer than 15 steps. Beyond that, the spreadsheet grid gets in the way and editing becomes tedious. For most people, Excel flowcharts are a quick reference tool rather than a permanent document — something you build once, share as a PDF, and move on.

Key Takeaways

  • Open the Insert menu, select Shapes, and choose a rectangle, diamond, or oval to represent each step in your process.
  • Use the Connector tool (also in Shapes) to draw lines between boxes, which will stay attached if you move the shapes.
  • Add text to each shape by double-clicking it and typing; format the text and shape colors using the Drawing Tools Format tab.
  • Excel flowcharts work best for straightforward, linear processes with fewer than 15 steps, because complex diagrams become hard to read and edit in a spreadsheet.
  • Save your flowchart as a PDF or image if you need to share it with people who do not have Excel, because the shapes may shift when opened on different computers.

Where to find the Shapes menu in Excel

In Excel for Windows, go to the Insert tab at the top of the ribbon. On the right side of that tab, you will see a Shapes button. Click it and a dropdown menu appears with shape categories: Basic Shapes, Flowchart, Callouts, and others. The Flowchart category holds the standard symbols: rectangles for processes, diamonds for decisions, ovals for start and end points, and parallelograms for data input or output.

In Excel for Mac, the Insert tab is also at the top. Look for the Shapes icon (it looks like a small rectangle with a circle and triangle). Click it to open the same shape library. The process is identical from there. If you cannot find Shapes, make sure you are on the Insert tab and not the Home tab. Some older versions of Excel place Shapes under Insert > Illustrations instead of as a direct button, but the shapes themselves are the same.

Drawing your first shape and adding text

Click the shape you want to use — start with a rectangle for a standard process step. Your cursor will change to a crosshair. Click and drag on your spreadsheet to draw the shape to the size you want. Release the mouse button and the shape appears. To add text, double-click the shape. A text cursor will appear inside it. Type your label — for example, "Receive Order" or "Check Inventory". When you are done typing, click outside the shape to finish editing. The text stays inside the shape and moves with it if you drag the shape to a new location.

If you need to change the text later, double-click the shape again. To format the text (make it bold, change the font size, or change the color), select the shape once, then use the Home tab formatting options or right-click and choose Format Shape. You can also adjust how the text sits inside the shape — centered, left-aligned, or wrapped across multiple lines — by right-clicking and selecting Format Shape, then choosing the Text Box tab.

Connecting shapes with lines that stay attached

Do not draw lines by hand. Instead, use the Connector tool so that lines stay attached to your shapes when you move them. Go back to Insert > Shapes and scroll down to the Connectors section. You will see several connector styles: straight, elbow (bent at right angles), and curved. Choose one.

Click and drag from the edge of one shape to the edge of another. The connector will snap to connection points on both shapes — you will see small circles appear on the shape edges when you hover over them. When you release the mouse, the line is drawn and locked to those points. If you later move either shape, the connector line moves with it and stays attached. If a connector line does not attach properly, right-click it and choose Connect Shapes. A dialog will open where you can manually select which shapes the line should connect and which points on each shape it should use.

Formatting shapes and choosing colors

Select a shape by clicking it once. The Drawing Tools Format tab will appear at the top of the ribbon (in some versions it says Shape Format). From there you can change the fill color, outline color, and outline thickness. Click Shape Fill to choose a solid color, gradient, or pattern. Click Shape Outline to change the line color and weight.

For a professional look, use the same fill color for all shapes of the same type — all rectangles one color, all diamonds another, all ovals a third. This makes the flowchart easier to read at a glance. Many flowchart templates use light blue for processes, light yellow for decisions, and light green for start/end points, but any consistent scheme works. You can also explore a quick style by clicking one of the preset designs in the Shape Styles group. These explore a coordinated color and shadow effect to the selected shape.

Arranging shapes so the flowchart is readable

As you add more shapes, arrange them in a logical order — usually top to bottom for a linear process, or left to right for a decision tree. Leave space between shapes so connector lines do not overlap and the flow is straightforward to follow. To align shapes neatly, select multiple shapes at once by holding Ctrl (or Cmd on Mac) and clicking each one. Then go to Drawing Tools Format > Arrange > Align and choose Align Left, Align Top, or Distribute Horizontally. This snaps all selected shapes to the same vertical or horizontal line, which makes the flowchart look organized.

If shapes are overlapping and you cannot click the one you want, right-click in the area and choose Select Objects. A small window opens where you can click the name of the shape you want to select. This is especially useful when many shapes are stacked. You can also use the arrow keys to nudge a selected shape one pixel at a time, which gives you fine control over positioning.

Saving and sharing your flowchart

Save your flowchart as a normal Excel file (.xlsx) if you plan to edit it later. The shapes and connectors will stay intact when you reopen the file on the same computer. If you need to send the flowchart to someone else, save it as a PDF or image instead. Go to File > Export As > Create PDF or File > Save As and choose PNG or JPEG format. This prevents the shapes from shifting if the other person opens it in a different version of Excel or on a different computer. Shapes in Excel do not always position identically across different systems, so exporting as an image is the safest way to preserve your layout.

If the person you are sending it to also has Excel and will need to edit it, send the .xlsx file and ask them to open it on a desktop version of Excel rather than the web version, since the web version has fewer shape and connector options. When you save as PDF, you can also choose to include only the area containing your flowchart rather than the entire spreadsheet, which makes the file smaller and cleaner to share.

When to use a different tool instead

Excel works for flowcharts with 5 to 15 steps that you will not change often. Beyond that, the spreadsheet grid gets in the way and editing becomes tedious. If your flowchart has many branches, loops, or decision points, or if multiple people need to edit it at the same time, a dedicated tool is faster. Google Drawings (free, built into Google Drive) is a good lightweight alternative if you want something simpler than Excel but do not want to pay for software. Lucidchart and Miro are paid options with more features, templates, and collaboration tools.

Microsoft Visio is Excel's official companion for diagramming, but it is a separate purchase and has a steeper learning curve. If you are building a flowchart to document a process that other people will follow, consider whether a straightforward text list or a table might work instead. Not every process needs a visual diagram — sometimes a numbered list is clearer and faster to read.

Frequently Asked Questions

Can I make a flowchart in Excel Online or Google Sheets?

Excel Online has a Shapes menu, but it is limited compared to the desktop version and connectors do not always behave the same way. Google Sheets has shapes but no connector tool, so you would have to draw lines by hand. For either web version, Google Drawings is a better choice because it was built for diagramming and has full connector support.

How do I add arrows to the end of connector lines?

Select the connector line by clicking it. Go to Drawing Tools Format > Shape Outline > Arrows and choose the arrow style you want. You can add an arrow to one end, both ends, or neither. This is useful for showing direction in your flowchart, especially if the flow is not strictly top-to-bottom.

What if I want to add a legend or key to explain what the shapes mean?

Add a text box (Insert > Text Box) somewhere on the spreadsheet away from your flowchart. Type your legend — for example, "Rectangle = Process, Diamond = Decision, Oval = Start/End". You can also insert small shapes next to the text to show what each symbol represents. This is helpful if your flowchart will be shared with people unfamiliar with standard flowchart symbols.

Can I convert an Excel flowchart to Visio or another program?

Not directly. You would need to recreate the flowchart in the new program. However, if you save your Excel flowchart as an image (PNG or PDF), you can import that image into another tool as a reference while you rebuild it. Some diagramming software can import images and trace them, but the result usually needs manual cleanup.

Why do my shapes move or misalign when I open the file on a different computer?

Excel does not lock shapes to an absolute position the way dedicated design software does. Different screen resolutions, zoom levels, and Excel versions can cause shapes to shift slightly. To prevent this, save your final flowchart as a PDF or image file, which freezes the layout and prevents any movement.