Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
Hey Roger,
I have the shortcut set up already - I am trying to highlight the cell without the color palette showing up. In 2003 if you assigned fill color as a shortcut, selecting the icon and hitting "enter" would fill the cell immediately with the last selected color (without having to navigate through the palette). You only got the palette to come up if you hit the "down" arrow key. In 2007 the color palette shows up as soon as you hit enter and you have to navigate back to the color to fill it in (hitting enter again fills in a white color). For example - I use the yellow fill quite a bit. When I type Alt-1 and push enter, the color palette pops up and I need to go down 6 and over 3 colors to reach yellow again. I am looking for a way that I can use the shortcut and instantly fill the cell instead of navigating through the palette. I know I'm nit-picking, but I got used to 2003 which fills the color immediately and the extra keystrokes required in 2007 are annoying the heck out of me! Best, Erik "Roger Govier" wrote: 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 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
Hi Erik
I see what you mean. XL2007 does not retain the last colour used. If you are always wanting to colour the cell yellow, you could copy this code into the ThisWorkbook module Sub SetCellColour() ActiveCell.Select With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 65535 .TintAndShade = 0 .PatternTintAndShade = 0 End With End Sub Copy codeAlt+F11double click This Workbookpaste the code. Alt+F11 to go back to the Excel sheetClick on the down arrow at the end of the QATMore CommandsChoose Commands fromMacrosscroll down to ThisWorkbook.SetCellColourAddOK Move the selection to first in the list on your QAT. Now, Alt+1 will fill the active cell with Yellow. -- Regards Roger Govier "Erik" wrote in message ... Hey Roger, I have the shortcut set up already - I am trying to highlight the cell without the color palette showing up. In 2003 if you assigned fill color as a shortcut, selecting the icon and hitting "enter" would fill the cell immediately with the last selected color (without having to navigate through the palette). You only got the palette to come up if you hit the "down" arrow key. In 2007 the color palette shows up as soon as you hit enter and you have to navigate back to the color to fill it in (hitting enter again fills in a white color). For example - I use the yellow fill quite a bit. When I type Alt-1 and push enter, the color palette pops up and I need to go down 6 and over 3 colors to reach yellow again. I am looking for a way that I can use the shortcut and instantly fill the cell instead of navigating through the palette. I know I'm nit-picking, but I got used to 2003 which fills the color immediately and the extra keystrokes required in 2007 are annoying the heck out of me! Best, Erik "Roger Govier" wrote: 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 |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
Hey Roger,
That should do it! Thanks for all your help. "Roger Govier" wrote: Hi Erik I see what you mean. XL2007 does not retain the last colour used. If you are always wanting to colour the cell yellow, you could copy this code into the ThisWorkbook module Sub SetCellColour() ActiveCell.Select With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 65535 .TintAndShade = 0 .PatternTintAndShade = 0 End With End Sub Copy codeAlt+F11double click This Workbookpaste the code. Alt+F11 to go back to the Excel sheetClick on the down arrow at the end of the QATMore CommandsChoose Commands fromMacrosscroll down to ThisWorkbook.SetCellColourAddOK Move the selection to first in the list on your QAT. Now, Alt+1 will fill the active cell with Yellow. -- Regards Roger Govier "Erik" wrote in message ... Hey Roger, I have the shortcut set up already - I am trying to highlight the cell without the color palette showing up. In 2003 if you assigned fill color as a shortcut, selecting the icon and hitting "enter" would fill the cell immediately with the last selected color (without having to navigate through the palette). You only got the palette to come up if you hit the "down" arrow key. In 2007 the color palette shows up as soon as you hit enter and you have to navigate back to the color to fill it in (hitting enter again fills in a white color). For example - I use the yellow fill quite a bit. When I type Alt-1 and push enter, the color palette pops up and I need to go down 6 and over 3 colors to reach yellow again. I am looking for a way that I can use the shortcut and instantly fill the cell instead of navigating through the palette. I know I'm nit-picking, but I got used to 2003 which fills the color immediately and the extra keystrokes required in 2007 are annoying the heck out of me! Best, Erik "Roger Govier" wrote: 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 |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade cell shortcut without bringing up palette
If it was also the last action, you can repeat with F4.
I wish it would work like 2003 - the colours are now so different and hard to use and I used to use them all the time. "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
Shade a cell | Excel Discussion (Misc queries) | |||
How do I shade only 1/2 of a cell? | Charts and Charting in Excel | |||
How can I change the color palette under Cell Shading? | Setting up and Configuration of Excel | |||
Bringing partial data from one cell into another | Excel Worksheet Functions |