Where is Quick Access Toolbar in Excel? By default, the Quick Access Toolbar is located in the upper left corner of the Excel window, above the ribbon. If you want QAT to be closer to the worksheet area, you can move it below the ribbon. How to customize Quick Access Toolbar in Excel. By default, the Excel Quick Access Toolbar contains only 3 buttons: Save, Undo and Redo. If there are a few other commands that you use frequently, you can add them to the Quick Access Toolbar too. 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. Right-click any Toolbar and choose Drawing Tools Customize, Toolbars tab, choose Drawing and hit Close Hit the Drawing Toolbars icon on the standard toolbar (the below screen capture happens to show Word, but it is similar in all the applications, but it is not available in PowerPoint, which opens the Drawing toolbar by default).

Lesson 4: Toolbars and the Task Pane

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.

/en/office2003basics/menus-/content/

Introduction

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

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:

Where is the drawing toolbar in excel and its label

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.

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.

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

Where is the drawing toolbar in excel automatically

To display the task pane:

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.

Challenge!

Practice showing and hiding toolbars in Office 2003 programs.

/en/office2003basics/dialog-boxes-and-wizards/content/

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.
If you want to collapse the ribbon so that none of the buttons are displayed, double-click the name of the tab.

Insert Shapes

Shapes - Click on the down arrow (outlined in red in this drawing) to see all of the available shapes.

Edit Shape - Change the shape of this drawing, convert it to a freeform shape, or edit the wrap points to determine how text wraps around the drawing.

Text Box - Insert a text box that can be positioned anywhere on the page.

Styles - Click on the down arrow (outlined in red in this drawing) to see all of the available shapes styles.

Shape Fill - Fill the selected shape with a solid color, gradient, picture, or texture.

Shape Outline - Specify the color, width, and line style for the outline of the selected shape.

Shape Effects - Apply a visual effect to the selected shape, such as shadow, glow, reflection, or 3-D rotation.

WordArt Styles

Styles -Click on the down arrow (outlined in red in this drawing) to see all of the available WordArt styles.

Text Fill - Fill the text with a solid color, gradient, picture, or texture.

Text Outline - Specify the color, width, and line style for the outline of the text.

Text Effects - Apply a visual effect to the text, such as shad

Where Is The Drawing Toolbar In Excel