How to Add the Draw Tab in MS Excel - TurboFuture - Technology
Updated date:

How to Add the Draw Tab in MS Excel

Joshua has work experience in manufacturing, distribution, and aerospace. He received his BBA in accounting from Kent State University.

how-to-add-the-draw-tab-in-ms-excel

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.

how-to-add-the-draw-tab-in-ms-excel

Next, click on more. This is the last option on the bottom left-hand side of the screen.

The more selection appears on the bottom left-hand side of the screen when the file tab is chosen.

The more selection appears on the bottom left-hand side of the screen when the file tab is chosen.

Next, select options to guide you to the general Excel options screen.

The options button allows an Excel user to see settings that can be changed to customize the Excel user interface.

The options button allows an Excel user to see settings that can be changed to customize the Excel user interface.

The goal is to add the draw tab to the Excel ribbon. So, the next step would be to choose the customize ribbon selection.

how-to-add-the-draw-tab-in-ms-excel

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.

how-to-add-the-draw-tab-in-ms-excel

Select the Ok button to exit the options menu.

how-to-add-the-draw-tab-in-ms-excel

The draw tab should now appear in the main tabs section of the ribbon as shown in the illustration below.

The draw tab will appear on the ribbon in the order that it appears on the customize ribbon option. These tabs can be changed to different orders.

The draw tab will appear on the ribbon in the order that it appears on the customize ribbon option. These tabs can be changed to different orders.

The tools of the draw tab appear in the illustration below.

Draw Tab View

This is the view seen after the draw tab is selected.

This is the view seen after the draw tab is selected.

Usefulness of the Draw Tab

Under that draw tab there are three different categories of options described in detail below.

Drawing Tools

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.

Convert

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.

Replay

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