I do a lot of shading (Home Font Fill Pattern Style) and I can not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined by
entering where it is located, i.e. see above for shading? Thanks!!

Home/Font section,select the dialog launcher. Or simply Ctrl+1. This brings
up Format Cells. Select the fill tab and go from there.

Tyro

"John Nettles" <John wrote in message
...
I do a lot of shading (Home Font Fill Pattern Style) and I can not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined by
entering where it is located, i.e. see above for shading? Thanks!!

You might also want to download the Excel 2003-2007 command reference guide.
http://office.microsoft.com/en-us/ex...491511033.aspx
The guidew are also available for Word, PowerPoint and Outlook.

Tyro

"John Nettles" <John wrote in message
...
I do a lot of shading (Home Font Fill Pattern Style) and I can not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined by
entering where it is located, i.e. see above for shading? Thanks!!

Thanks for responding but maybe I didn't make myself clear enough. I
understand how to get the cell shaded with a pattern, I would like to know
what the icon is called or look like. For instance the "open an exisiting
file" icon is the pic of the file folder opened with a little arrow above it.
I am looking for the "1 click" icon for doing the pattern shading (cell has
background of shaded dots). Thanks again, John

"Tyro" wrote:

Home/Font section,select the dialog launcher. Or simply Ctrl+1. This brings
up Format Cells. Select the fill tab and go from there.

Tyro

"John Nettles" <John wrote in message
...
I do a lot of shading (Home Font Fill Pattern Style) and I can not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined by
entering where it is located, i.e. see above for shading? Thanks!!

You can modify the ribbon in Excel 2007 with VBA. The icons are in
Winows/sytem32 somehwere, I have forgotten where. Others know.

Tyro

"John Nettles" wrote in message
...
Thanks for responding but maybe I didn't make myself clear enough. I
understand how to get the cell shaded with a pattern, I would like to know
what the icon is called or look like. For instance the "open an exisiting
file" icon is the pic of the file folder opened with a little arrow above
it.
I am looking for the "1 click" icon for doing the pattern shading (cell
has
background of shaded dots). Thanks again, John

"Tyro" wrote:

Home/Font section,select the dialog launcher. Or simply Ctrl+1. This
brings
up Format Cells. Select the fill tab and go from there.

Tyro

"John Nettles" <John wrote in message
...
I do a lot of shading (Home Font Fill Pattern Style) and I can not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined by
entering where it is located, i.e. see above for shading? Thanks!!

I appreciate you responding but while know and understand that control 1 is a
mini-shortcut to the format cells overall box, I am looking for the icon that
is one step, i.e. like the "comma" symbol on the little icon/toolbar command
that makes the numer in the cell a "1,2345.67" format versus a 12345.67"
format a 1-step process. The older version of Excel had the icon/toolbar
command for giving a user-defined default cell pattern background but I can
not find it on the 2007 version. Thanks again.

"Tyro" wrote:

You can modify the ribbon in Excel 2007 with VBA. The icons are in
Winows/sytem32 somehwere, I have forgotten where. Others know.

Tyro

"John Nettles" wrote in message
...
Thanks for responding but maybe I didn't make myself clear enough. I
understand how to get the cell shaded with a pattern, I would like to know
what the icon is called or look like. For instance the "open an exisiting
file" icon is the pic of the file folder opened with a little arrow above
it.
I am looking for the "1 click" icon for doing the pattern shading (cell
has
background of shaded dots). Thanks again, John

"Tyro" wrote:

Home/Font section,select the dialog launcher. Or simply Ctrl+1. This
brings
up Format Cells. Select the fill tab and go from there.

Tyro

"John Nettles" <John wrote in message
...
I do a lot of shading (Home Font Fill Pattern Style) and I can not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined by
entering where it is located, i.e. see above for shading? Thanks!!

Click on the office button (the Orb in the top left corner)
click on the Excel Options button
Click on the Customize option on the left hand side

You can modify the Quick Access Toolbar (QAT) here.

There's a Comma Style under All Commands.

John Nettles wrote:

I appreciate you responding but while know and understand that control 1 is a
mini-shortcut to the format cells overall box, I am looking for the icon that
is one step, i.e. like the "comma" symbol on the little icon/toolbar command
that makes the numer in the cell a "1,2345.67" format versus a 12345.67"
format a 1-step process. The older version of Excel had the icon/toolbar
command for giving a user-defined default cell pattern background but I can
not find it on the 2007 version. Thanks again.

"Tyro" wrote:

You can modify the ribbon in Excel 2007 with VBA. The icons are in
Winows/sytem32 somehwere, I have forgotten where. Others know.

Tyro

"John Nettles" wrote in message
...
Thanks for responding but maybe I didn't make myself clear enough. I
understand how to get the cell shaded with a pattern, I would like to know
what the icon is called or look like. For instance the "open an exisiting
file" icon is the pic of the file folder opened with a little arrow above
it.
I am looking for the "1 click" icon for doing the pattern shading (cell
has
background of shaded dots). Thanks again, John

"Tyro" wrote:

Home/Font section,select the dialog launcher. Or simply Ctrl+1. This
brings
up Format Cells. Select the fill tab and go from there.

Tyro

"John Nettles" <John wrote in message
...
I do a lot of shading (Home Font Fill Pattern Style) and I can not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined by
entering where it is located, i.e. see above for shading? Thanks!!







--

Dave Peterson

This sounds like a custom button, added to the boxed version of Excel.
You'll have to similarly modify Excel 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John Nettles" wrote in message
...
I appreciate you responding but while know and understand that control 1 is
a
mini-shortcut to the format cells overall box, I am looking for the icon
that
is one step, i.e. like the "comma" symbol on the little icon/toolbar
command
that makes the numer in the cell a "1,2345.67" format versus a 12345.67"
format a 1-step process. The older version of Excel had the icon/toolbar
command for giving a user-defined default cell pattern background but I
can
not find it on the 2007 version. Thanks again.

"Tyro" wrote:

You can modify the ribbon in Excel 2007 with VBA. The icons are in
Winows/sytem32 somehwere, I have forgotten where. Others know.

Tyro

"John Nettles" wrote in message
...
Thanks for responding but maybe I didn't make myself clear enough. I
understand how to get the cell shaded with a pattern, I would like to
know
what the icon is called or look like. For instance the "open an
exisiting
file" icon is the pic of the file folder opened with a little arrow
above
it.
I am looking for the "1 click" icon for doing the pattern shading (cell
has
background of shaded dots). Thanks again, John

"Tyro" wrote:

Home/Font section,select the dialog launcher. Or simply Ctrl+1. This
brings
up Format Cells. Select the fill tab and go from there.

Tyro

"John Nettles" <John wrote in
message
...
I do a lot of shading (Home Font Fill Pattern Style) and I can
not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined
by
entering where it is located, i.e. see above for shading? Thanks!!