Excell 2007 version. Shpe fill options
 

I liked the fill options we had in Excel 2003. They do not appear to be
available in Excel 2007 - which only has the picture texture fill options. I
want the standard cross hatching etc fill options. How can I get these in
Excel 2007?

Excell 2007 version. Shpe fill options
 

On the Home tab, in the Font box, click the little arrow in the right bottom corner. There you will find the "old" options

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ecoeng" wrote in message ...
|I liked the fill options we had in Excel 2003. They do not appear to be
| available in Excel 2007 - which only has the picture texture fill options. I
| want the standard cross hatching etc fill options. How can I get these in
| Excel 2007?

Excell 2007 version. Shpe fill options
 

Thanks Nick

When I click on to the little arrow I get a "Format cell" diallogue box but
no option to switch to "old" options. It is shapes that I want the old fill
options for such as circles, rectangles ets - and not cells.

Regards

Andrew Dakers

"Niek Otten" wrote:

On the Home tab, in the Font box, click the little arrow in the right bottom corner. There you will find the "old" options

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ecoeng" wrote in message ...
|I liked the fill options we had in Excel 2003. They do not appear to be
| available in Excel 2007 - which only has the picture texture fill options. I
| want the standard cross hatching etc fill options. How can I get these in
| Excel 2007?

Excell 2007 version. Shpe fill options
 

Yes, you're right; seems like it can't be done.

You can still use VBA to do it, like

Selection.ShapeRange.Fill.Patterned msoPatternNarrowHorizontal

The pattern names can be found in VBA help

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ecoeng" wrote in message ...
| Thanks Nick
|
| When I click on to the little arrow I get a "Format cell" diallogue box but
| no option to switch to "old" options. It is shapes that I want the old fill
| options for such as circles, rectangles ets - and not cells.
|
| Regards
|
| Andrew Dakers
|
| "Niek Otten" wrote:
|
| On the Home tab, in the Font box, click the little arrow in the right bottom corner. There you will find the "old" options
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "ecoeng" wrote in message ...
| |I liked the fill options we had in Excel 2003. They do not appear to be
| | available in Excel 2007 - which only has the picture texture fill options. I
| | want the standard cross hatching etc fill options. How can I get these in
| | Excel 2007?
|
|
|

Excell 2007 version. Shpe fill options
 

Or, if you still have a file with shapes with patterns, copy and paste the patterns (CTRL+SHIFT+C, CTRL+SHIFT+V)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Niek Otten" wrote in message ...
| Yes, you're right; seems like it can't be done.
|
| You can still use VBA to do it, like
|
| Selection.ShapeRange.Fill.Patterned msoPatternNarrowHorizontal
|
| The pattern names can be found in VBA help
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "ecoeng" wrote in message ...
|| Thanks Nick
||
|| When I click on to the little arrow I get a "Format cell" diallogue box but
|| no option to switch to "old" options. It is shapes that I want the old fill
|| options for such as circles, rectangles ets - and not cells.
||
|| Regards
||
|| Andrew Dakers
||
|| "Niek Otten" wrote:
||
|| On the Home tab, in the Font box, click the little arrow in the right bottom corner. There you will find the "old" options
||
|| --
|| Kind regards,
||
|| Niek Otten
|| Microsoft MVP - Excel
||
|| "ecoeng" wrote in message ...
|| |I liked the fill options we had in Excel 2003. They do not appear to be
|| | available in Excel 2007 - which only has the picture texture fill options. I
|| | want the standard cross hatching etc fill options. How can I get these in
|| | Excel 2007?
||
||
||
|
|