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 -
|