Written by Allen Wyatt (last updated August 17, 2024)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365
In addition to working with numbers and text within cells of a workbook, Excel allows you to highlight your worksheets by adding simple drawings. One classification of drawing objects you can add are called, simply, Shapes. In many respects Shapes can be considered simple drawing objects because they are very simple to create, even though they appear complex. Excel defines quite a few different Shapes (over 150), all selectable by using the tools on the Insert tab of the ribbon.
When you click on the Shapes tool (in the Illustrations group) you actually display a series of menus from which you can pick the shape you want. For instance, let's say you wanted to draw a heart. You would click on the Shapes tool, look in the Basic Shapes category, then click the heart shape.
Once you select a shape, you draw it by positioning the mouse pointer at one corner of where you want to place the shape, clicking the mouse button, and dragging until you reach the opposite corner. When you release the mouse button the shape appears on the screen.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8108) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
Excel allows you to add borders to a cell or range of cells. If the available borders aren't exactly as you desire, you ...
Discover MoreDrawing objects can be layered over each other in almost any manner you desire. If you want to change the order in which ...
Discover MoreYou can add text to all sorts of drawing shapes, not just text boxes. Here's how easy it is.
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2026 Sharon Parq Associates, Inc.
Comments