Cell color pattern styles in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the old Excel version, one could add a drop-down box to the tool bar for
formatting the pattern color and pattern styles of a cel. It looked and
functioned a lot like the "fill color" button.

I can't seem to find its counterpart in the 2007 version -- neither on the
ribbon, or in the available buttons for the toolbar. I used this button
CONSTANTLY! Is it just called something weird now - or did they do away
with this very useful tool?

And if it is no longer available without opening the format dialogue box
every time I want to add a pattern to a cel, might there be a macro that can
create the button for me?
 
I don't mean to be obtuse -- but where do I find that --- on the ribbon bar,
or on the toolbar add-on menu, or...? I can't find it.
 
Hi Candida

Select the cell or range of cells which you wish to format.
Right click with your mouse which brings up a context dialogue box.
Select Format>Fill> and use the dropdown on Pattern Style to see a range
of fill patterns.
 
Sigh... Well, thank you both for your time. But that isn't any faster than
opening the font dialogue box directly. What I was looking for was a button
for the toolbar that I could just tap every time I wanted to fill a cell with
the pattern I'd selected. Is there such a thing? The old Excel had it - but
I can't find it any more.
 
Hi Candida

You could choose Home tab>Cell Styles>New cell styles and create a style
for the ones you use most frequently.
They will appear as the top row when you click the dropdown on Cell
Styles.
 
Ai yai. That would mean that I'd have a monstrous library of a million
different cell styles.

So the answer is no -- it has been done away with? How shortsighted.
There are buttons for many features that a simple right-click can take care
of (like deleting or adding columns, etc.) how could they not have created
one for something that takes several steps to do - when they had it in the
old excel already?

I'm so frustrated. Is there possibly a macro that could create it? I'm not
knowledgeable enough to write it myself.
 
Back
Top