Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keyboard short cut for highlighting a field
is there a keyboard short cut or a way to create a shortcut to hightlight a
cell easily with a default or specific color. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keyboard short cut for highlighting a field
None that I have ever heard of.
A macro with a shortcut key could do the trick Sub color_it() For Each cell In Selection cell.Interior.ColorIndex = 3 'red Next End Sub Assign a shortcut key combo. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 15:42:00 -0800, Cindy wrote: is there a keyboard short cut or a way to create a shortcut to hightlight a cell easily with a default or specific color. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keyboard short cut for highlighting a field
Or do it all in one line:
Sub Color_it2() Selection.Interior.ColorIndex = 3 'red End sub <vbg Gord Dibben wrote: None that I have ever heard of. A macro with a shortcut key could do the trick Sub color_it() For Each cell In Selection cell.Interior.ColorIndex = 3 'red Next End Sub Assign a shortcut key combo. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 15:42:00 -0800, Cindy wrote: is there a keyboard short cut or a way to create a shortcut to hightlight a cell easily with a default or specific color. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keyboard short cut for highlighting a field
If I have lots of cells to color, i color the first one and then
select the others and press Alt + Enter, which repeats the last command, in that case coloring. Maybe that helps you Carlo On Jan 18, 9:05*am, Gord Dibben <gorddibbATshawDOTca wrote: None that I have ever heard of. A macro with a shortcut key could do the trick Sub color_it() For Each cell In Selection * * *cell.Interior.ColorIndex = 3 * 'red Next End Sub Assign a shortcut key combo. Gord Dibben *MS Excel MVP On Thu, 17 Jan 2008 15:42:00 -0800, Cindy wrote: is there a keyboard short cut or a way to create a shortcut to hightlight a cell easily with a default or specific color.- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keyboard short cut for highlighting a field
As Dave Peterson points out in another message, this could be changed to do all
cells at once without the loop. Sub color_it() Selection.Interior.ColorIndex = 3 'red End Sub Gord On Thu, 17 Jan 2008 16:05:06 -0800, Gord Dibben <gorddibbATshawDOTca wrote: None that I have ever heard of. A macro with a shortcut key could do the trick Sub color_it() For Each cell In Selection cell.Interior.ColorIndex = 3 'red Next End Sub Assign a shortcut key combo. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 15:42:00 -0800, Cindy wrote: is there a keyboard short cut or a way to create a shortcut to hightlight a cell easily with a default or specific color. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keyboard short cut for highlighting a field
Geez
Now I'm chasing around to all my latest posts and advising OP's of your advice. Again.......thanks On Thu, 17 Jan 2008 18:21:36 -0600, Dave Peterson wrote: Or do it all in one line: Sub Color_it2() Selection.Interior.ColorIndex = 3 'red End sub <vbg Gord Dibben wrote: None that I have ever heard of. A macro with a shortcut key could do the trick Sub color_it() For Each cell In Selection cell.Interior.ColorIndex = 3 'red Next End Sub Assign a shortcut key combo. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 15:42:00 -0800, Cindy wrote: is there a keyboard short cut or a way to create a shortcut to hightlight a cell easily with a default or specific color. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Keyboard short cut for highlighting | Excel Discussion (Misc queries) | |||
Summary field highlighting. | Excel Discussion (Misc queries) | |||
How do I change font size in Excel with keyboard short cuts? | Excel Discussion (Misc queries) | |||
can you customize a keyboard short cut in excel? | Excel Discussion (Misc queries) | |||
whats the keyboard short cut for inserting a row in Excel | New Users to Excel |