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?

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?

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?

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?
|
|
|

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?
||
||
||
|
|