Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
quick access toolbar
In the 2003 version of excel you could add the patterns as a button like the
colour button and text colour button. I cannot find this function in the commands to enable me to add it to the quick access toolbar. Has anyone else found it and if so could they let me know where it is? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
quick access toolbar
Hi,
To view the Customize dialog box, do one of the following: €¢ On the View menu, point to Toolbars and then click Customize. €¢ On the Tools menu, click Customize 1. Click the Commands Tab. 2. In the Categories list, click Insert. 3. In the Commands list, click AutoShapes. 4. Drag the AutoShapes button and place it in the toolbars displayed below the applications menu. 5. Click the AutoShapes button. The AutoShapes Toolbar appears. 6. Click Basic Shapes button in the AutoShapes Toolbar. 7. Click on Rounded Rectangle 8. Click and drag to create a shape in the Excel Sheet. 9. Right-click on the selected rounded rectangle and click Format AutoShapes. The Format AutoShapes dialog box appears. 10. Click Color and Lines Tab. 11. Under Fill, click the Color list. 12. Click Fill Effects. 13. Click the Pattern Tab. Choose by clicking the any pattern. 14. Click OK. Returns to AutoShapes dialog box. 15. Click OK. Challa Prabhu "Jan" wrote: In the 2003 version of excel you could add the patterns as a button like the colour button and text colour button. I cannot find this function in the commands to enable me to add it to the quick access toolbar. Has anyone else found it and if so could they let me know where it is? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
quick access toolbar
Hi
Thanks very much for your answer but I was not clear in my original post I'm on version 2007 and you cannot customize the toolbar in this way anymore. You can customize the quick access toolbar but I cannot find the icon for patterns to put on the quick access toolbar. "challa prabhu" wrote: Hi, To view the Customize dialog box, do one of the following: €¢ On the View menu, point to Toolbars and then click Customize. €¢ On the Tools menu, click Customize 1. Click the Commands Tab. 2. In the Categories list, click Insert. 3. In the Commands list, click AutoShapes. 4. Drag the AutoShapes button and place it in the toolbars displayed below the applications menu. 5. Click the AutoShapes button. The AutoShapes Toolbar appears. 6. Click Basic Shapes button in the AutoShapes Toolbar. 7. Click on Rounded Rectangle 8. Click and drag to create a shape in the Excel Sheet. 9. Right-click on the selected rounded rectangle and click Format AutoShapes. The Format AutoShapes dialog box appears. 10. Click Color and Lines Tab. 11. Under Fill, click the Color list. 12. Click Fill Effects. 13. Click the Pattern Tab. Choose by clicking the any pattern. 14. Click OK. Returns to AutoShapes dialog box. 15. Click OK. Challa Prabhu "Jan" wrote: In the 2003 version of excel you could add the patterns as a button like the colour button and text colour button. I cannot find this function in the commands to enable me to add it to the quick access toolbar. Has anyone else found it and if so could they let me know where it is? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
quick access toolbar
Hi Jan,
Sorry, I was referring to Version 2003. This may not relevant to 2007. Challa Prabhu "Jan" wrote: Hi Thanks very much for your answer but I was not clear in my original post I'm on version 2007 and you cannot customize the toolbar in this way anymore. You can customize the quick access toolbar but I cannot find the icon for patterns to put on the quick access toolbar. "challa prabhu" wrote: Hi, To view the Customize dialog box, do one of the following: €¢ On the View menu, point to Toolbars and then click Customize. €¢ On the Tools menu, click Customize 1. Click the Commands Tab. 2. In the Categories list, click Insert. 3. In the Commands list, click AutoShapes. 4. Drag the AutoShapes button and place it in the toolbars displayed below the applications menu. 5. Click the AutoShapes button. The AutoShapes Toolbar appears. 6. Click Basic Shapes button in the AutoShapes Toolbar. 7. Click on Rounded Rectangle 8. Click and drag to create a shape in the Excel Sheet. 9. Right-click on the selected rounded rectangle and click Format AutoShapes. The Format AutoShapes dialog box appears. 10. Click Color and Lines Tab. 11. Under Fill, click the Color list. 12. Click Fill Effects. 13. Click the Pattern Tab. Choose by clicking the any pattern. 14. Click OK. Returns to AutoShapes dialog box. 15. Click OK. Challa Prabhu "Jan" wrote: In the 2003 version of excel you could add the patterns as a button like the colour button and text colour button. I cannot find this function in the commands to enable me to add it to the quick access toolbar. Has anyone else found it and if so could they let me know where it is? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 customize quick access toolsbar adding menus commands | Excel Discussion (Misc queries) | |||
Does anyone have access to an audit toolbar? | Excel Discussion (Misc queries) | |||
Grouping of icons in the Quick Access Toolbar... Excel 2007 | Excel Discussion (Misc queries) | |||
quick access bar | Excel Discussion (Misc queries) | |||
How to access excel toolbar | Excel Discussion (Misc queries) |