shade cell shortcut without bringing up palette

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

alt o brings up format menu,e selects cell tab or arrow selcts patterns,tab
then arrow to tselect colour.I guess you can assign a shortcut key
--
paul

remove nospam for email addy!



"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

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

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

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

I use the shade cell feature quite a bit, so I dragged the button so it was
underneath the main menu (it shows up right underneath my "File" menu) to the
left of the "new file" button. This is done by selecting Tools - Customize
and then dragging buttons wherever you want.

Once that is set I push Alt, then Ctrl+tab and the highlight button is
selected. Then I can push Enter to highlight the cell.

"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

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

Hi Erik

You can do the same thing in XL2007, utilizing the QAT (Quick Access
Toolbar)
Click on the down arrow at the end of the QATMore CommandsChoose Commands
fromall Commandsscroll down to Fill ColourAddOK

Now the option is on the QAT and can be used as you do in XL2003

--
Regards
Roger Govier



"Erik" wrote in message
...
I use the shade cell feature quite a bit, so I dragged the button so it was
underneath the main menu (it shows up right underneath my "File" menu) to
the
left of the "new file" button. This is done by selecting Tools -
Customize
and then dragging buttons wherever you want.

Once that is set I push Alt, then Ctrl+tab and the highlight button is
selected. Then I can push Enter to highlight the cell.

"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

Hey Roger -

I know that you can put the shortcut on the QAT - my problem is that when I
use keyboard shortcuts to fill the cell, it brings up the color table and I
am required to manually select my color. I am wondering if I there is a way
I can just use the keyboard shortcut and fill the cell without bringing up
the color palette.

I think this is only an issue using the keyboard - with the mouse you can
just click the icon and it fills the cell, but the keyboard requires you to
go through the table. The same thing goes for changing font color...

"Roger Govier" wrote:

Hi Erik

You can do the same thing in XL2007, utilizing the QAT (Quick Access
Toolbar)
Click on the down arrow at the end of the QATMore CommandsChoose Commands
fromall Commandsscroll down to Fill ColourAddOK

Now the option is on the QAT and can be used as you do in XL2003

--
Regards
Roger Govier



"Erik" wrote in message
...
I use the shade cell feature quite a bit, so I dragged the button so it was
underneath the main menu (it shows up right underneath my "File" menu) to
the
left of the "new file" button. This is done by selecting Tools -
Customize
and then dragging buttons wherever you want.

Once that is set I push Alt, then Ctrl+tab and the highlight button is
selected. Then I can push Enter to highlight the cell.

"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

Hi Erik

Once you have added the Font colour to the QAT, just press Alt.
The letters and Numbers associated with each item show up.
If you move the icon to the first in the list on the QAT, it will become Alt
1, so pressing Alt1 will give you the colour palette to select from.

--
Regards
Roger Govier



"Erik" wrote in message
...
Hey Roger -

I know that you can put the shortcut on the QAT - my problem is that when
I
use keyboard shortcuts to fill the cell, it brings up the color table and
I
am required to manually select my color. I am wondering if I there is a
way
I can just use the keyboard shortcut and fill the cell without bringing up
the color palette.

I think this is only an issue using the keyboard - with the mouse you can
just click the icon and it fills the cell, but the keyboard requires you
to
go through the table. The same thing goes for changing font color...

"Roger Govier" wrote:

Hi Erik

You can do the same thing in XL2007, utilizing the QAT (Quick Access
Toolbar)
Click on the down arrow at the end of the QATMore CommandsChoose
Commands
fromall Commandsscroll down to Fill ColourAddOK

Now the option is on the QAT and can be used as you do in XL2003

--
Regards
Roger Govier



"Erik" wrote in message
...
I use the shade cell feature quite a bit, so I dragged the button so it
was
underneath the main menu (it shows up right underneath my "File" menu)
to
the
left of the "new file" button. This is done by selecting Tools -
Customize
and then dragging buttons wherever you want.

Once that is set I push Alt, then Ctrl+tab and the highlight button is
selected. Then I can push Enter to highlight the cell.

"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