Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
To get to the Drawing toolbar is really inconvienent. Is there a way to put
an icon in the quick toolbar? Thanks Irv |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Hold the Alt button down and type n sh -- Regards Roger Govier "Irv" wrote in message ... To get to the Drawing toolbar is really inconvienent. Is there a way to put an icon in the quick toolbar? Thanks Irv |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I do that it just brings up the (n) Insert bar and (sh) opens Shape's box.
Thanks Rodger, Irv "Roger Govier" wrote: Hi Hold the Alt button down and type n sh -- Regards Roger Govier "Irv" wrote in message ... To get to the Drawing toolbar is really inconvienent. Is there a way to put an icon in the quick toolbar? Thanks Irv |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Irv" wrote in message ... When I do that it just brings up the (n) Insert bar and (sh) opens Shape's box. Thanks Rodger, Irv "Roger Govier" wrote: Hi Hold the Alt button down and type n sh -- Regards Roger Govier "Irv" wrote in message ... To get to the Drawing toolbar is really inconvienent. Is there a way to put an icon in the quick toolbar? Thanks Irv |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Mike Middleton" wrote: 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 "Irv" wrote in message ... When I do that it just brings up the (n) Insert bar and (sh) opens Shape's box. Thanks Rodger, Irv "Roger Govier" wrote: Hi Hold the Alt button down and type n sh -- Regards Roger Govier "Irv" wrote in message ... To get to the Drawing toolbar is really inconvienent. Is there a way to put an icon in the quick toolbar? Thanks Irv |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Irv" wrote in message ... 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 "Mike Middleton" wrote: 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 "Irv" wrote in message ... When I do that it just brings up the (n) Insert bar and (sh) opens Shape's box. Thanks Rodger, Irv "Roger Govier" wrote: Hi Hold the Alt button down and type n sh -- Regards Roger Govier "Irv" wrote in message ... To get to the Drawing toolbar is really inconvienent. Is there a way to put an icon in the quick toolbar? Thanks Irv |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "Irv" wrote: To get to the Drawing toolbar is really inconvienent. Is there a way to put an icon in the quick toolbar? Thanks Irv i need the anwer |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "lenlevi" wrote in message ... "Irv" wrote: To get to the Drawing toolbar is really inconvienent. Is there a way to put an icon in the quick toolbar? Thanks Irv i need the anwer |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? "Ron de Bruin" wrote: 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" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "lenlevi" wrote in message ... "Irv" wrote: To get to the Drawing toolbar is really inconvienent. Is there a way to put an icon in the quick toolbar? Thanks Irv i need the anwer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Missing Drawing Toolbar in Excel 2007 | Excel Discussion (Misc queries) | |||
Drawing toolbar. | Excel Worksheet Functions | |||
drawing toolbar | Excel Discussion (Misc queries) | |||
How do I show the file URL in the toolbar in Office 2007? | Excel Discussion (Misc queries) | |||
drawing toolbar icons | Charts and Charting in Excel |