Hi i know that "SHIFT + spacebar" 'highlights' an excel row. But what I want to do is actually to 'highlight' it such that the background is yellow. Is there a keyboard shortcut for that?
5 Answers
You can just click on the row number so that the entire row is selected.Now just go to the fill color option, choose your desired color, and the entire row will be highlighted.
2i'm looking for a shortcut also. the only method I found so far is the F4 button. it mimics your last action.
So I would suggest: highlight with color the row you want, and select another row you want to highlight with the same color and press F4.
1You click the little paint bucket icon in the ribbon, in the Font section. There is a little arrow next to it which gives you an option to change the colour.
If you press Alt on any Office program, small key-symbols appear on the ribbon tabs. If you press one of those keys, more symbols appear on that tab's buttons. Those symbols denote the shortcuts for the buttons. So, each shortcut consists of three key presses after each other:
- Alt
- The tab's shortcut key.
- The button's shortcut key.
The shortcut to select highlight in excel 2013 for windows is Alt H + H (hold down ALT and tap H twice). Probably works on other versions with the ribbon.
This works well for highlighting rows too, just use the shortcut to select a row in Excel - Shift + Space Bar, followed by the highlight shortcut (Alt + H + H)
