How to insert drawing objects in Excel

To enhance your Excel worksheet, you can insert drawing objects like shapes, arrows, or text boxes. Here’s a straightforward guide to inserting and manipulating drawing objects:

Inserting Drawing Objects

Click on the Insert tab in the Excel ribbon at the top of your Excel window.

In the Illustrations group, locate and click on the Shapes button.

insert ribbon objects

Drawing Your Object

A gallery of shapes will appear. Select the shape you want to insert by clicking on it. Common options include rectangles, circles, arrows, and more.

choose ribbon object

To draw your chosen shape, click and hold the left mouse button, and then drag the cursor to create the object’s size and shape on your worksheet.

drawing object in Excel

After creating the object, you can click and drag it to reposition it on the worksheet. Additionally, you can customize it further by changing its fill color, border color, text (if applicable), and other formatting options.

You can adjust the object’s size by clicking and dragging the resizing handles located at its edges or corners. To rotate the object, click and drag the circular handle at the top of the object.

For text-based objects like text boxes, you can double-click inside the object to add or edit text.

Once you’re satisfied with the object’s appearance and placement, you can click outside the object to finish. Your drawing object is now part of your Excel worksheet.

See also  How to remove green triangles from cells

Advanced Formatting and Effects on Drawing Objects

Excel provides various tools for advanced formatting and applying eye-catching effects to your drawing objects, allowing you to create visually appealing and informative worksheets. Here’s how you can enhance your drawing objects with advanced formatting and effects:

Access Format Tab

Once you’ve inserted a drawing object (shape, arrow, text box, etc.), select the object by clicking on it. This action will activate the Format tab in the Excel ribbon, which offers extensive formatting options.

Customize Shape Styles

Under the Format tab, you’ll find the Shape Fill and Shape Outline buttons in the Shape Styles group. Click these buttons to choose from various fill colors, gradients, and outline styles for your object. You can even specify custom colors or remove the outline if desired.

Save Custom Styles

If you’ve configured a particular combination of formatting and effects that you want to reuse, you can save it as a custom style. Under the Format tab, use the Shape Fill and Shape Outline options to access More Fill Colors and More Outline Colors. Within these dialogs, you can save custom colors and apply them to other