Drawing in Excel

Last Updated :

-

Blog Author :

WallStreetMojo Team

Edited by :

Ashish Kumar Srivastav

Reviewed by :

Dheeraj Vaidya, CFA, FRM

Table Of Contents

arrow

How to Use Drawing Tool in Excel?

  1. We must first go to the "Insert" tab in the Excel toolbar.


    Drawing Excel Step 1

  2. Then, choose a drawing object which we want.


    If we want to insert a shape, we must click on "Shapes."

    Drawing Excel Step 2

    Draw an object which we want to draw in Excel

    Drawing Excel Step 3

    Next, we must click on the format to customize our drawing, e.g., color, borderline, object size, effects, etc.

    Drawing Excel Step 4

  3. Suppose we want to add a text box to any object.


    If you want to add some text to any of the drawings, we must go to "Insert" and select the "Text Box":

    Step 5

    Click the "Text Box," draw the text box horizontal or vertical, and write in that box. Finally, click the "Enter" key.
    Step 5-1

    If we want to change the color of the text or customize the text box, we need to go to "Format" and click on "Shape Styles."

    Step 5-2

  4. As shown below, this one is the final rectangular box with customization in color.


    Step 5-3

Benefits

  1. We can make your data more attractive using the drawing tool in Excel.
  2. It is easy to insert the shapes and charts in Excel.
  3. It is very easy to customize the object as per the requirement.
  4. We can insert multiple objects as much as required, with no limit.
  5. We can easily rotate and flip the shapes using the rotate command in the "Arrange" group under the "Format" tab.
  6. It is easy to add text to a shape.
  7. If we want to prepare any chart, it helps us connect the shapes with the help of lines.

Tip and Tricks for Inserting Excel Drawing Tools

  1. We can easily add text to all the shapes we create in an Excel sheet.
  2. We can utilize the vast number of drawing objects accessible on the "Insert" tab of the ribbon.
  3. Excel does not restrain us from just numbers and content in your worksheets. We can likewise include diverse kinds of shapes.
  4. Excel enables us to flip drawing objects either on a level plane or vertically.
  5. Drawing objects can be layered over one another practically any way we want if we need to change the request in which those drawing objects are layered.
  6.  Need to fill a drawing object with various sorts of impacts? Excel offers a few effects to make our drawing objects "pop."