Joshua is a graduate student at the USF. He has interests in business technology, analytics, finance, and lean six sigma.
The draw tab allows you to make drawing edits within a spreadsheet. This tab is found on the Excel ribbon and is not always enabled.
To enable this tab for more functionality, start by clicking the file tab.
Next, click on more. This is the last option on the bottom left-hand side of the screen.
Next, select options to guide you to the general Excel options screen.
The goal is to add the draw tab to the Excel ribbon. So, the next step would be to choose the customize ribbon selection.
Next, find draw in the right column under the main tabs section and click the empty box to put a check mark in it.
Take notice to the order that these tabs. If you don't like where the tabs are located on the ribbon, you can always come back here to rearrange them. To do so, just drag them to the the desired position.
Select the Ok button to exit the options menu.
The draw tab should now appear in the main tabs section of the ribbon as shown in the illustration below.
The tools of the draw tab appear in the illustration below.
Draw Tab View
Usefulness of the Draw Tab
Under that draw tab there are three different categories of options described in detail below.
This section allows you to use two different pen options and a highlighter to draw with. Color pallets and thickness settings are offered for each writing tool for ease fo use. An eraser tool is also available to clean up any mistakes. Additionally, there is a lasso tool that allows you to turn a drawing into an object. To stop using these tools make sure you press the escape button.
This section has a few interesting tools that convert drawings into useful shapes & mathematical expressions. Select ink to shape and you can draw any common shape and the tool will create a perfect shape object from your work. Use the ink to math tool to covert equations drawings to an objects that can be moved and resized.
Lastly, the ink replay option allows you to replay the strokes made on any drawing created.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2020 Joshua Crowder