Shortcut in Excel

  • Thread starter Thread starter Jake Rich
  • Start date Start date
J

Jake Rich

Is there a keyboard shortcut in Excel that will change a highlighted row's
color? I know how to highlight a row (shift+space), but after that I don't
know the shortcut to change its color.

Thanks!
 
Jake,

There is no built-in shortcut: you would need to write a macro and
assign it to a shortcut to get that functionality.

HTH,
Bernie
MS Excel MVP
 
This macro will select the current row(s) and allow you to set a color.

Sub EntireRow_ChangeColor()
selection.EntireRow.Select
Application.Dialogs(xlDialogPatterns).Show
End Sub

HTH
-Dave Smith
 
Thank you Dave!

Dave Smith said:
This macro will select the current row(s) and allow you to set a color.

Sub EntireRow_ChangeColor()
selection.EntireRow.Select
Application.Dialogs(xlDialogPatterns).Show
End Sub

HTH
-Dave Smith
Click to expand...
 
Back
Top