#1   Report Post  
Posted to microsoft.public.excel.misc
Jan Jan is offline
external usenet poster
 
Posts: 159
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Jan Jan is offline
external usenet poster
 
Posts: 159
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2007 customize quick access toolsbar adding menus commands Søren Thade Petersen Excel Discussion (Misc queries) 3 November 18th 06 05:38 PM
Does anyone have access to an audit toolbar? mlorch Excel Discussion (Misc queries) 0 September 21st 06 09:31 PM
Grouping of icons in the Quick Access Toolbar... Excel 2007 R. Hamel Excel Discussion (Misc queries) 0 June 3rd 06 06:04 PM
quick access bar Jean-Marc Excel Discussion (Misc queries) 0 May 30th 06 08:00 AM
How to access excel toolbar saslimm Excel Discussion (Misc queries) 2 January 10th 05 03:03 AM


All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"