Drawing in Excel (Basics & Application)

In this article, you will learn about drawing in Excel. More specifically, you will learn about the basics, drawing flow charts, and free-form drawings. You can use the Shapes feature inside the Insert tab to draw in Excel. Although Excel is not designed as a graphic design application, you can do basic drawings with it. You can also draw freehand in Excel using the Draw tab.

You can use the flowchart to show the decision points and visualize various processes. This provides a sequence of events, which aids in understanding a process more efficiently.

Drawing in Excel


Download the Practice Workbook


List of Basic Shapes of Drawing Tools in Excel

  1. Lines: Used to connect different parts of a drawing.
  2. Rectangles: Usually shows the main process field.
  3. Basic Shapes: Used for decision-making illustration.
  4. Block Arrows: Shows the direction for processes.
  5. Equation Shapes: Shows the mathematical equation.
  6. Flow Chart: This is inserted to show a process from start to finish.
  7. Stars and Banners: Decorative items.
  8. Callouts: Used for notes and comments.

List of Shapes in Excel


How to Insert a Basic Shape Drawing in Excel

  • Select Rectangle: Rounded Corners from the Insert tab. You will find it in the Shapes of the Illustrations group.

Inserting Rounded Rectangle from Excel Drawing Tools

  • Click and drag the mouse around the sheet, then release to draw a rectangle surrounding the selected area. You can select different colors from the Shape Format tab.

Shape Format Tab for the Rounded Rectangle


How to Use Drawing Tools to Draw Flowcharts in Excel

  • Insert the rectangle with rounded corners. We are adding the flow chart below it.
  • Select Line Arrow and draw in the worksheet from the rectangle down.

Inserting Line Arrow from Excel Drawing Tools

  • Here’s the start of the flowchart.

Output of Rounded Rectangle and Line Arrow

  • Repeat for other boxes while connecting them with the lines. You can use different types of boxes.

Output of Flow Chart using Drawing Tools in Excel


Free Form Drawing in Excel

How to Enable the Draw Tab in Excel

  • Go to File, select Excel Options, and choose Customize Ribbon.
  • Select Draw from the Main Tabs section and press OK.

Enabling Draw Tab in Excel

Read More: How to Use Drawing Tools in Excel


How to Draw a Free-Form Drawing in Excel

  • From the Draw tab, select the red pen and draw on the spreadsheet.

Drawing Triangle using Red Pen in Excel

  • You can convert this into a shape. Click on the drawing and select the Ink to Shape option.

Ink to shape Feature

  • The freehand drawing will be turned into a shape based on Excel’s closest approximation of your drawing.
  • Alternatively, there are two freeform shapes at the end of the Lines shape, which you can use for freehand drawing in Excel.

Output of Ink to Shape Feature

Read More: How to Remove Drawing Tools in Excel


Things to Remember

  • You can make your charts more informative using the drawing feature in Excel.
  • You can layer one shape over another and control the order using the Selection Pane feature under the Arrange group of the Insert tab.
  • Always keep the shapes close to activating the connecting points.
  • Although there is no limit on the maximum number of shapes in Excel, you should not use them unnecessarily to keep the Excel file size smaller.

Frequently Asked Questions

Does Excel have Smart Art?

Yes, Excel has a Smart Art feature. In the Insert tab, you will find the Smart Art feature under the Illustration group.

Is it possible to rotate, move, or resize a drawing object in Excel?

  • Rotate: If you select any drawing object, you will see a rotate icon at the top. To rotate it, click and hold and move it in the desired direction.
  • Move: Select the shape and hover the mouse pointer to the object. Then, the mouse cursor will change. Now, drag to move the object.
  • Resize: After selecting the drawing object, you will see small rounded shapes around it. Hover the mouse pointer over this, and the mouse pointer will change. Then drag it to resize the object. Additionally, you can hold the Shift button and resize it to keep the aspect ratio constant.

Is there a way to group multiple objects in Excel?

You can select multiple drawing objects and right-click to bring up the context menu. After that, select Group.


Drawing in Excel: Knowledge Hub


<< Go Back to Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

Tags:

Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo