Excell 2007 version. Shpe fill options

E

ecoeng

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

Niek Otten

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

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

ecoeng

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
 
N

Niek Otten

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

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

Niek Otten

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get cross-hatching in Excel 2007? 3
Fill Options for 2007 Excell Chart 5
Fill options 1
Series fill only copying and fill series greyed out 1
Excel 2007 - Color Fill Tear Off 1
How do I create a cross hatch fill in Powerpoint 2007? 4
Excel 2007 lists 2
Fill color floating menu 2

Top