Return to site

Where Is The Drawing Toolbar In Excel

broken image


Using the Drawing Tools Tab in Excel 2007 This tab only appears when a shape is selected. As soon as the shape is deselected, this tab disappears. Tip: If you are unsure what the function of a feature is, let your cursor hover over the button (in Excel) to see a pop-up box explaining the feature. All apps include a Draw tool on the Draw tab of the Ribbon for switching between inking mode and selection mode. There is also an ink selection tool, Lasso Select,.

  1. Where Is The Drawing Toolbar In Excel Automatically
Home > Documents > Office >Where is Form Toolbar in Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365
  1. Sometimes, the only way to select a graphic is by using the Selector Tool on the Drawing Toolbar. Here's the Drawing toolbar, in case you're not familiar with it. I've extended the Drawing menu so you can see the options available there, which are so important, and of which so many people are unaware. Here's some tips about using Drawing tools.
  2. Toolbar in Excel The Toolbar is an area where you can add different commands or tools associated with excel. By default, it is located above the ribbon with different tools and is visible in the upper right corner of the Excel window.

Where is Form Toolbar in Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365?

The Form Toolbar disappeared, and we can't get the Form Toolbar in Ribbon quickly. It is hard to edit our forms without these useful buttons, functionalities, and features. For working efficiently in future, it is quite necessary to find out them. Here are two methods for you to discover the Form Toolbar in Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365:

How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013, 2016, 2019 and 365?
Just download Classic Menu for Office 2007 or Classic Menu for Office
Kutools for Excel: 120 Powerful New Features for Excel.
Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.


Familiar method to get Form Toolbar if you have Classic Menu for Office

Classic Menu for Office will bring back your familiar working environment of Microsoft Office 2003. So that you can get Form Toolbar with familiar way at ease:

  • Click the Tools drop down menu in main menus;
  • Click the Control item;
  • Continue to click the Legacy Tools;
  • Then you will view the several buttons under Legacy Forms. The Legacy Forms and its buttons are the Form Toolbar of Microsoft Office 2003.

Figure 1: Form Toolbar in Classic Menu

Add drawing toolbar to excel

Get Form Toolbar in Office 2007 if you do not have Classic Menu for Office

It is quite hard to find out the Form Toolbar in Ribbon if you are a beginner of Microsoft Office 2010 or 2007. The Form Toolbar is hidden deeply in Ribbon, and patience is needed to dig it.
Firstly we need to show Developer Tab in Ribbon in PowerPoint 2007:

  • Click the Office button;
  • Click the Word Options at the bottom;
  • Then you will enter into Word Options dialog, click the Popular button at the left bar;
  • Check the Show Developer tab in the Ribbon item under Top options for working with Word;
  • Click the Ok button at the bottom;
  • Now the Developer tab will be added into the far right in Ribbon.

Figure 2: Add Developer tab into Office 2007 Ribbon

After the developer tab showing in Ribbon:

  • Go to the Developer tab;
  • Move to the Control group;
  • Click the Legacy drop down button, then you will view the Legacy Forms buttons. These buttons are Form Toolbar buttons.

Figure 3: Form Toolbar in Office 2007 Ribbon

Free draw in excel

Get Form Toolbar in Office 2010/2013/365 if you do not have Classic Menu for Office

It is also very difficult to discover Form Toolbar in Office 2010/2013/365. What's worse, you won't find out Form Toolbar with the method we described above. Here lists the method to get Form Toolbar in Office 2013:

  • Click the File tab in the Ribbon, and you will view backstage view;
  • Click the Options button at left bar;
  • Then the Word Options dialog pops up (It may also be Excel Options, PowerPoint Options…).
  • Click the Customize Ribbon button at left bar;
  • You can locate the 'Developer' on the right side, please check it and click OK.

Figure 4: Add Developer Tab into Office 2013 Ribbon

Then you will view that the Developer tab is added after View tab. Go to the Controls group under Developer tab, click the Click the Legacy drop down button, then you will view the Legacy Forms buttons. These buttons are Form Toolbar buttons.

More tips for Microsoft Office 2007, 2010, 2013 and 365

Classic Menu for Office

Brings your familiar old menus and toolbars of Office 2003 (2002, 2000) back to Microsoft Office 2007, 2010, 2013 and 365. You can use Office 2007/2010/2013/2016 (includes Office 365) immediately and efficiently, and don't need any trainings or tutorials when upgrading to Microsoft Office (includes Word, Excel, and more ..) 2007, 2010 or 2013.

Screen Shot of Classic Menu for Word

Classic Menu for Office

It includes Classic Menu for Word, Excel, PowerPoint, Access, Outlook, OneNote, Publisher, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365 (includes Office 365).

Classic Menu for Office 2007

It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

< Documentation‎ | OOoAuthors User Manual‎ | Impress Guide
  • The Drawing toolbar


The Drawing toolbar collects the majority of the tools normally used to create graphic objects. If this toolbar is not showing, select View > Toolbars > Drawing from the main menu bar.


First section of Drawing toolbar with drawing objects tools.

Doctor strange download full movie in hindi subtitle. The toolbar can be divided into two parts. The first part (shown above) contains drawing objects. The tools in this part of the Drawing toolbar are:

  • Select: selects objects. To select multiple objects click on the top leftmost object and while keeping the mouse button pressed, drag the mouse to the bottom rightmost object of the intended selection. A marching ants rectangle identifying the selection area is displayed. It is also possible to select several objects by pressing the Control button while selecting the individual objects.
  • Line: draws a straight line.
  • Arrow: draws a straight line ending with an arrowhead. The arrowhead will be placed where you release the mouse button.
  • Rectangle: draws a rectangle. Press the Shift button to draw a square.
  • Ellipse: draws an ellipse. Press the Shift button to draw a circle.
  • Text: creates a text box with text aligned horizontally.
  • Vertical text: creates a text box with text aligned vertically. This tool is available only when Asian language support has been enabled in Tools > Options > Language Settings > Languages.
  • Curve: draws a curve. Click the black triangle for more options, shown below. Note that the title of the submenu when undocked is Lines.

Available curve options.
  • Connectors: draws a connector line between two figures. Click the black triangle for additional connectors, shown below. The use of connectors is described in Working with connectors.

Connectors options.
  • Basic Shapes, Symbol Shapes, Block Arrows, Flowcharts, Callouts, Stars: click the black triangle to open a toolbar showing the available shapes in that category. The default shapes are shown below. Select the desired shape, then draw as normal. Keep the Shift key pressed to obtain a shape where the height and width are equal.
Where Is The Drawing Toolbar In Excel

Get Form Toolbar in Office 2007 if you do not have Classic Menu for Office

It is quite hard to find out the Form Toolbar in Ribbon if you are a beginner of Microsoft Office 2010 or 2007. The Form Toolbar is hidden deeply in Ribbon, and patience is needed to dig it.
Firstly we need to show Developer Tab in Ribbon in PowerPoint 2007:

  • Click the Office button;
  • Click the Word Options at the bottom;
  • Then you will enter into Word Options dialog, click the Popular button at the left bar;
  • Check the Show Developer tab in the Ribbon item under Top options for working with Word;
  • Click the Ok button at the bottom;
  • Now the Developer tab will be added into the far right in Ribbon.

Figure 2: Add Developer tab into Office 2007 Ribbon

After the developer tab showing in Ribbon:

  • Go to the Developer tab;
  • Move to the Control group;
  • Click the Legacy drop down button, then you will view the Legacy Forms buttons. These buttons are Form Toolbar buttons.

Figure 3: Form Toolbar in Office 2007 Ribbon

Get Form Toolbar in Office 2010/2013/365 if you do not have Classic Menu for Office

It is also very difficult to discover Form Toolbar in Office 2010/2013/365. What's worse, you won't find out Form Toolbar with the method we described above. Here lists the method to get Form Toolbar in Office 2013:

  • Click the File tab in the Ribbon, and you will view backstage view;
  • Click the Options button at left bar;
  • Then the Word Options dialog pops up (It may also be Excel Options, PowerPoint Options…).
  • Click the Customize Ribbon button at left bar;
  • You can locate the 'Developer' on the right side, please check it and click OK.

Figure 4: Add Developer Tab into Office 2013 Ribbon

Then you will view that the Developer tab is added after View tab. Go to the Controls group under Developer tab, click the Click the Legacy drop down button, then you will view the Legacy Forms buttons. These buttons are Form Toolbar buttons.

More tips for Microsoft Office 2007, 2010, 2013 and 365

Classic Menu for Office

Brings your familiar old menus and toolbars of Office 2003 (2002, 2000) back to Microsoft Office 2007, 2010, 2013 and 365. You can use Office 2007/2010/2013/2016 (includes Office 365) immediately and efficiently, and don't need any trainings or tutorials when upgrading to Microsoft Office (includes Word, Excel, and more ..) 2007, 2010 or 2013.

Screen Shot of Classic Menu for Word

Classic Menu for Office

It includes Classic Menu for Word, Excel, PowerPoint, Access, Outlook, OneNote, Publisher, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365 (includes Office 365).

Classic Menu for Office 2007

It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

< Documentation‎ | OOoAuthors User Manual‎ | Impress Guide
  • The Drawing toolbar


The Drawing toolbar collects the majority of the tools normally used to create graphic objects. If this toolbar is not showing, select View > Toolbars > Drawing from the main menu bar.


First section of Drawing toolbar with drawing objects tools.

Doctor strange download full movie in hindi subtitle. The toolbar can be divided into two parts. The first part (shown above) contains drawing objects. The tools in this part of the Drawing toolbar are:

  • Select: selects objects. To select multiple objects click on the top leftmost object and while keeping the mouse button pressed, drag the mouse to the bottom rightmost object of the intended selection. A marching ants rectangle identifying the selection area is displayed. It is also possible to select several objects by pressing the Control button while selecting the individual objects.
  • Line: draws a straight line.
  • Arrow: draws a straight line ending with an arrowhead. The arrowhead will be placed where you release the mouse button.
  • Rectangle: draws a rectangle. Press the Shift button to draw a square.
  • Ellipse: draws an ellipse. Press the Shift button to draw a circle.
  • Text: creates a text box with text aligned horizontally.
  • Vertical text: creates a text box with text aligned vertically. This tool is available only when Asian language support has been enabled in Tools > Options > Language Settings > Languages.
  • Curve: draws a curve. Click the black triangle for more options, shown below. Note that the title of the submenu when undocked is Lines.

Available curve options.
  • Connectors: draws a connector line between two figures. Click the black triangle for additional connectors, shown below. The use of connectors is described in Working with connectors.

Connectors options.
  • Basic Shapes, Symbol Shapes, Block Arrows, Flowcharts, Callouts, Stars: click the black triangle to open a toolbar showing the available shapes in that category. The default shapes are shown below. Select the desired shape, then draw as normal. Keep the Shift key pressed to obtain a shape where the height and width are equal.

Available shapes for Impress.

The second part of the Drawing toolbar, shown below, contains more generic tools.


The second section of the Drawing toolbar with utility tools.

Those tools are:

  • Edit points: select this tool, then select a shape or a line, to edit the individual points that form the shape or line.
  • Glue points: select this tool to edit the glue points of a graphic object. Glue points are the positions where connector lines terminate or start. See Managing glue points for instructions.
  • Fontwork: opens the Fontworks gallery. See Using Fontwork for further information.
  • From file: equivalent to Insert > Picture > From file on the main menu. See Chapter 4 for details.
  • Gallery: opens the gallery. Equivalent to Tools > Gallery on the main menu. See Chapter 4 for details.
  • Rotate: select this tool to rotate an object. As rotation is considered a formatting attribute, this is discussed in Chapter 6.
  • Align object: see Aligning shapes.
  • Arrange object: see Arranging shapes.
  • Extrusion On/Off: switches 3D effects on or off for the selected object. Clicking this button also opens the 3D settings toolbar. See Working with 3D shapes for details.
  • Interaction: opens a dialog where you can specify the interaction between the user and the object. See Setting up interaction with a shape or image.
  • Visible buttons: use the black triangle to open a menu that allows to add or subtract buttons to the toolbar. The step by step procedure is given in Chapter 4 of the Getting Started guide.


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).

Where Is The Drawing Toolbar In Excel Automatically

Retrieved from 'https://wiki.openoffice.org/w/index.php?title=Documentation/OOoAuthors_User_Manual/Impress_Guide/The_Drawing_toolbar&oldid=107262'




broken image