Thanks for the suggestion. Don't think it works in 2007 though.

"Dave Peterson" wrote:

Maybe...

If you use the dropdown arrow on the fill icon, you'll see a dotted area above
the "no fill" area.

You can click on that and "drag off". Then you have that mini-toolbar that is
available in the worksheet area. Click on a cell that's has a fill color and if
it shows up in that mini-toolbar, it'll be selected.

Or maybe not...

Gord Dibben wrote:

Can you tell us how you did it xl2003?

Would be handy trick to know.

Gord Dibben MS Excel MVP

On Sun, 21 Oct 2007 16:47:00 -0700, Erik wrote:

Should clarify this is in Excel 2007. I know that Alt-H-H is the shortcut to
shade a cell - I'd just like to do it instantly without all the color options
popping up. I was able to do this in 2003.

"Erik" wrote:

When I use the keyboard shortcut to shade cells it always brings up the color
palette, and I have to select the color manually. Using the keyboard, is
there a way to select my last used color without bringing up the color
palette? I know you can just click on the button with the mouse, but I'm
looking for the keyboard shortcut equivalent.

Thanks

--

Dave Peterson