Office 2007 Drawing Toolbar

I

Irv

To get to the Drawing toolbar is really inconvienent. Is there a way to put
an icon in the quick toolbar?
Thanks Irv
 
I

Irv

When I do that it just brings up the (n) Insert bar and (sh) opens Shape's box.
Thanks Rodger,
Irv
 
M

Mike Middleton

Irv -

You wrote: > To get to the Drawing toolbar is really inconvienent. <

How have you been getting there?

Excel's Help says "In 2007 Office release programs, to perform tasks that
you used to perform from the Drawing toolbar (such as inserting a shape,
drawing a line, and adding a picture, clip art, SmartArt graphic, or
WordArt), you click an option in the Illustrations group, or Text group, on
the Insert tab."

- Mike
 
I

Irv

If you go into Excel 2007 and click on Insert and then click on anything in
the Illustration group you do not get the drawing toolbar. You have to click
on shapes and then on a shape of any kind. You then have to go to the cell
and click on it. Then the drawing toolbar opens up. Then you have to click
on Format and then on Shape outline to get to something as simple as "line
weight". Thats a lot of clicks.
I was just trying to find an easier way, and thought that an icon might be
available. Try changing the line weight (thickness of the cell outlines)
yourself and you will see what I mean.
Thanks Mike,
Irv
 
M

Mike Middleton

Irv -

Yes, some tasks require more clicks in Excel 2007.

I was confused by your use of the phrase "drawing toolbar."

In Excel 97-2003 the Drawing Toolbar can be obtained by View | Toolbars |
Drawing.

In Excel 2007, as the Help excerpt below says, those tasks require the
Insert ribbon (Illustrations group or Text group).

As far as I know, there is no way to obtain the old Drawing Toolbar in Excel
2007.

When you format a shape in Excel 2007, I don't think you are using the old
Drawing Toolbar.

- Mike
 
J

Jon Peltier

Yes, some tasks require more clicks in Excel 2007.

"Some", or "a great many"? This is the biggest weakness of the new UI, that
tasks take longer than before, even though a completely new user can find
some items more quickly.
As far as I know, there is no way to obtain the old Drawing Toolbar in
Excel 2007.
Click to expand...

That's one baby that went down the drain with the bathwater, resulting in
many added clicks..

- Jon
 
R

Ron de Bruin

There is no drawing toolbar in Excel 2007

You can add any control or group in the QAT by right clicking on it in the ribbon
and clicking on "Add to QAT bar"
 
D

Don

The information below from MSFT Help does NOT exist!!
1. Under Drawing Tools, on the Format tab, in the Shape Styles group, click
the arrow next to Shape Outline.

If you do not see the Drawing Tools or Format tabs, make sure that you
selected a line.
2. Point to Dashes, and then click the line style that you want.

Finally discovered that they left out the fact that you have to go to
INSERT, SHAPES. SELECT LINE and draw it. Then go back and highlight the line.
Only then can you get the format tab by RIGHT clicking so you can select
arrows, dotted, color etc. Help section needs Help.
Does anyone know a way to do this with fewer clicks?
 
Top