Does an excel keyboard shortcut to highlight a cell yellow exist?
27,164
No, but you could make one. You have the ability to assign VBA macros to any key you want.
First, open up your personal macro store in the VBE. Press ALT+F11
Then paste this macro in:
Sub HighlightYellow()
'
' HighlightYellow Macro
'
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
Now save your personal macro workbook and close the VBE.
Press ALT+F8
Then assign a shortcut to your new macro.
Related videos on Youtube
Author by
user7758051
Updated on September 18, 2022Comments
-
user7758051 almost 2 years
Is there an keyboard shortcut to highlight a cell yellow (or maybe just the most recent color used)?
What I am not looking for (I want something that is preset in excel and more efficient):
- Alt-H-H + using arrow keys to navigate to yellow in pallette
- Adding color palette to Quick Access
- Creating my own shortcut or macro (Ctrl+Shift+#some key#)
- F4 to repeat last keystroke