Excel is best known for formulas, data, and grids, but it also includes a surprisingly capable set of freehand drawing tools.
Whether you want to highlight key values in a table, sketch a quick diagram, or insert a handwritten equation, the Draw tab gives you more flexibility than most users ever discover. Here's a look at what's available and how to put it to use.
The Draw tab (1) is especially useful when working with a touchscreen and pen. Touch input is possible but less precise.
Even without a touchscreen, you can use this tab to highlight specific values in a table with your mouse. You can show or hide the tab via File > Options > Customize Ribbon.
Highlights and Handwritten Comments
To highlight specific values in a table, just click or tap one of the markers under Drawing Tools (2) and use it to mark the values. To turn it off, click or tap the Draw (3) icon. Highlights will appear as transparent graphics over the cell contents, and you can handle them like graphic objects if you need to.
You can easily adjust all pens’ line thickness and color by opening the palette via the small arrow (4) at the bottom right. The Action Pen (5) on the far right lets you draw numbers that Excel automatically converts into numeric values. Pens offer not only colors but also various textures, and you can use a pen’s context menu to change its composition and order.
Your custom pen selection will be available in all Office apps.
Creating Sketches
Besides highlighting or handwriting notes on table data, you can use pens to create quick sketches. Excel can even turn a rough line into a perfect triangle or circle. To do this, circle the object with the lasso tool (1) and then click the Ink to Shape (2) button.
Inserting Mathematical Equations
It works the same way with math. To insert a mathematical equation into a sheet to document a calculation, click Ink to Math (3) and draw the formula by hand after clicking or tapping Write in the dialog box. Your handwriting will instantly be converted into math in the header. If there are errors, you can circle them by using Select and Correct and usually fix them by choosing from the suggested list. Click Insert to add the formula to the worksheet as a graphic object.
To remove a hand-drawn element, use the Erase icon (4) and drag the small eraser over the element. This doesn’t apply to converted shapes or equations, which you can delete like regular graphic objects. To select multiple items at once, click the Lasso Selection icon (5) and draw a lasso around the items.
You can also use the Ink Replay (6) feature, which plays your freehand drawings in the order you created them.
On the Review tab, use Ink > Hide Ink to hide all freehand elements when you don’t need them. They won’t be deleted, though, and you can click the same button to show them again.
Conclusion
Excel's drawing tools won't replace dedicated illustration software, but they fill a genuine gap for users who want to annotate data, sketch ideas, or document calculations without leaving the spreadsheet. The Draw tab is worth a few minutes of exploration, especially if you work with a touchscreen or regularly share workbooks where visual callouts would add clarity.
Editor’s note: This post has been adapted from a section of the book Excel: The Comprehensive Guide by Helmut Vonhoegen. Helmut is a freelance author and IT consultant. He has published more than 80 books since 1992 and written numerous articles in specialist journals. His focus is Microsoft Office, Windows, web programming, and XML.
This post was originally published 7/2026.
Comments