Where Is The Drawing Toolbar In Excel

< Documentation‎ OOoAuthors User Manual‎ Draw Guide
  • Toolbars

Applies only to Word, PowerPoint, and Excel: To select part of a drawing or words written in ink, use the Lasso Select tool. (This tool can't select non-ink objects—that is, shapes, pictures, etc.) Under Draw Tools on the Ribbon, tap Lasso Select. Click on the Layoutbutton in the Slidesgroup on the HOMEtab of the Ribbon and select Blank Activating the Drawing Tools To activate the Drawing Toolsyou simply have to use one. When you do, the Drawing Tools Formattab is added to the Ribbon.

Drawing in excel means making a shape in excel, now excel has provided us with many tools for drawing, some of them are the predefined drawings or predefined shapes and also there is option for free form of drawing where user can design a drawing by using mouse, this is available in the shapes in the insert tab of excel. The Drawing Toolbar. Excel's Drawing toolbar includes a wide range of tools you can use to add lines, arrows, shapes, and text boxes to your worksheets and charts.Through creative use of these tools, you can add impact and improve appearance for all of your Excel documents.

The various Draw toolbars can be displayed or hidden, according to your needs.

To display or hide the toolbars, click View > Toolbars. On the menu that appears, choose which toolbars you want to display.

You can also select the icons that you wish to appear on the toolbars. Some toolbars have icons that are not displayed by default, but you can choose to display them; you can also hide any icons that do appear on the toolbars by default. To change the visible icons on any toolbar, click the arrow at the right-hand end of the toolbar and select Visible Buttons. On the list of the available tools that appears, select or de-select the icons you want to be visible. A checkmark next to an icon indicates that it will be visible.

Floating toolbars

Many toolbar icons are marked with a small arrow. The arrow indicates that this icon has additional functions. Click the arrow, and a sub-menu or floating toolbar appears, showing its additional functions (see Figure 6).

You may wish to keep this sub-menu displayed on your screen, but in a different position. You can make a sub-menu into a floating toolbar. To do so, click the area at the top of the sub-menu, drag it across the screen, and then release the mouse button. Floating toolbars can be re-docked on an edge of the screen or within one of the existing toolbar areas at the top of the screen, as described in Chapter 4.

Most icons marked with the small arrow can become floating toolbars. The floating toolbar capability is common to all components of the OpenOffice.org suite.

Figure 6: An arrow next to a icon indicates additional functions.

Tip: If you double-click on an icon on a floating toolbar, the command corresponding to that icon is executed. You can then repeat this as often as you like. To exit from this mode, press the Esc key or click on another icon (for example [[Image:]]).

Note: The icon of a floating toolbar always shows the last used command. This can mean that the icon you see on your screen may differ from that shown in this Guide.

Similarly, click on the arrow on the title bar of a floating toolbar to display additional functions (see Figure 7).

Figure 7: An arrow on a floating toolbar indicates additional functions.

In Draw, as in all components of OpenOffice.org, toolbars can be moved to a new position with the mouse. Hover the mouse over the end of the toolbar (look for two vertical columns of dots) until the cursor becomes two crossed arrows and then drag and drop as desired).

The tools available in the various toolbars are explained in the following sections.

Standard toolbar

The Standard toolbar is the same for all components of OpenOffice.org and is not described in detail here.

Figure 8: Standard toolbar.

Line and Filling toolbar

The Line and Filling toolbar lets you modify the main properties of a drawing object: the icons and pulldown lists vary according to the type of object selected. For example, to change the thickness of a line with the spinner, hover the mouse over the spinner and click the up or down arrow to achieve the desired thickness.

Figure 9: Line and Filling toolbar.

In the example above, the available functions enable you to change the color, style and width of the line drawn, or the fill color, style, and other properties of an object. The object must first be selected with a mouse click. If the selected object is a text frame, the buttons for line style and fill color are changed to Invisible.

When text is selected, the Line and Filling toolbar changes to the Text Formatting toolbar, which is very similar to the Formatting toolbar in Writer. A more detailed explanation of the buttons on this toolbar can be found in Chapter 4.

Figure 10: Text Formatting toolbar.

Drawing toolbar

The Drawing toolbar is the most important toolbar in Draw. It contains all the necessary functions for drawing various geometric and freehand shapes and organizing them on the page. It is described in detail in Chapter 2.

Figure 11: Drawing toolbar.

Color bar

To display the Color bar, use View > Toolbars > Color Bar. The toolbar then appears at the bottom of the workspace and shows you the current color palette.

Figure 12: Color bar.

This toolbar lets you rapidly choose the color of the various objects—lines, areas, 3D effects—in your drawing. The first box in the panel corresponds to transparency (no color).

You can access several specialised color palettes in Draw as well as change individual colors to your own taste. This is done using the Area dialog, reached by choosing Format > Area as shown in Figure 13, or the pouring can symbol on the Line and Filling toolbar (Figure 9).

Figure 13: Two ways to display the Area dialog.

On the Area dialog, choose the tab marked Colors (Figure 14).

To load another palette, click on the Load Color List button (circled). The file selector dialog asks you to choose one of the standard OpenOffice.org palettes (files bearing the file extension *.soc). For example, web.socis a color palette that is particularly adapted to creating drawings that are going to appear in Web pages; the colors will be correctly displayed on workstations with screens displaying at least 256 colors.

A more detailed description of color palettes and their options can be found in Chapter 8.

Figure 14. Changing the color palette.

Options toolbar

The Options toolbar lets you activate or deactivate various drawing aids. The Options Bar is not one of the toolbars displayed by default. To display it, select View > Toolbars > Options.

Figure 15: Options toolbar.

The most important options for starting work in Draw are enclosed in red above. Their functions are described in the table below. The other buttons are described in detail in the relevant chapters of this Guide.

Table 1: Functions on the Options toolbar

Display or hide the Grid
Display or hide the Guides
Display or hide Guides when moving
Snap to Grid
Snap to Guides
Snap to Page Margins
Snap to Object Borders
Snap to Object Points

Drawing grid and guides

Draw offers a grid as a drawing aid. The grid can be turned on or off by clicking on the Grid icon on the Options toolbar. The points of the grid displayed on the screen are not shown on the printed drawing. The color, spacing and resolution of the grid points can be individually chosen for each axis. This is described in more detail in Chapter 8 (in the section titled “Configuring the Grid”).

Guides are special “helper lines” that can be turned on or off by clicking on the Guides icon on the Options toolbar. Draw offers a “Snap” function (1), with which you can place drawings exactly on these guides. All snap functions are described in detail in Chapter 8.

Showing the position of the object while moving it makes positioning the object much easier. If this function is activated, pairs of vertical and horizontal lines enclosing the object are shown while moving the object. These lines extend to the edges of the drawing area. This function is also described in detail in Chapter 8.

(1) Drawing objects can be snapped; that is, they can be attached to a grid point, a guide, a page margin, or a border or point of another object.

Customizing toolbars

For greater control, you can add other functions to a toolbar and move tools between toolbars. To do this, in the View > Toolbars menu select Customize, click on the Toolbars tab (see Figure 16), select the toolbar you want to change, and then select the desired buttons for that toolbar. Each toolbar has a different list of buttons.

Figure 16: Customizing a toolbar.

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Retrieved from 'https://wiki.openoffice.org/w/index.php?title=Documentation/OOoAuthors_User_Manual/Draw_Guide/Toolbar&oldid=71127'

Lesson 4: Toolbars and the Task Pane



By the end of this lesson, you should be able to:

  • Discuss toolbars common to Office 2003 programs
  • Hide and display toolbars
  • Discuss the task pane's basic functionality
  • Hide and display the task pane

What is a toolbar?

In the previous lesson, you learned to execute Office 2003 commands using menus. You can also execute many commands using a toolbar.

Toolbars contain icons, or buttons, representing the most commonly used commands. Microsoft created such toolbars because often it's easier to click a button than it is to open a menu and search for a command.

Certain toolbar buttons (and their corresponding commands) are unique to specific Office programs, but there are others such as New, Open, Save, and Print that are common to Word, Excel, and PowerPoint.

If you forget what an icon on a toolbar means, hover your mouse pointer over the button. A label will appear telling you what the button does. This label is called a tooltip.

It doesn't matter which way you choose to execute common commands. It's just a matter of preference.

Standard and Formatting toolbars

The Standard and Formatting toolbars are the two most commonly used toolbars in Office 2003 programs. When you open Word, Excel, or PowerPoint, the Standard and Formatting toolbars are turned on by default.

The Standard toolbar is located just below the menu bar. It contains buttons representing commands such as New, Open, Save, and Print.

The Formatting toolbar is located by default next to the Standard toolbar. It contains buttons representing text modifying commands, such as font, text size, bold, numbering, and bullets. To view the entire Formatting toolbar, click the small arrow (in Word) or double arrows (in Excel and PowerPoint) on the far right of the Formatting toolbar.

Note: Microsoft Outlook features Standard, Advanced, and Web toolbars.

Displaying and hiding toolbars

Where is the drawing toolbar in excel file

As you just learned, the Standard and Formatting toolbars are turned on by default in Word 2003, Excel 2003, and PowerPoint 2003. However, all of these programs (including Outlook 2003) include other helpful toolbars that can be displayed or hidden as you need them.

To display or hide a toolbar:

  • Choose ViewToolbars from the menu bar.
  • The cascading toolbar menu appears.
  • Check marks appear next to currently displayed toolbars.
  • Click the toolbar you want to display, or click the toolbar you want to hide.

Excel Drawing Tools Menu

The task pane

The task pane is located on the right side of your screen and is present when you first start an Office 2003 program. Use the task pane to create new files, open files, search for files, cut and paste text and graphics, and apply styles to your Office files from a single location.

To hide the task pane:

  • Choose ViewToolbars from the menu bar.
  • The cascading toolbar menu appears.
  • Choose Task Pane.
  • The task pane is hidden.


Where Is The Drawing Toolbar In Excel 2013

  • Click the small X in the upper right corner of the task pane.

Where Is The Drawing Toolbar In Excel 2010

To display the task pane:

Where Is The Drawing Toolbar In Excel 2010

  • Choose ViewToolbars from the menu bar.
  • The cascading toolbar menu appears.
  • Choose Task Pane.
  • The task pane displays on the right side of the window.
Learn more about the task pane's many functions in units 2 and 3.


  • Practice showing and hiding toolbars in Office 2003 programs.