When a new window appears, choose a name for a new macro, but more importantly choose a keyboard shortcut. The fastest way to create a macro is to use the little icon in the bottom left corner of the worksheet. Macro The last keyboard shortcut I would like to present is the one assigned by you to a macro. In the above example, we filled cell B2 with a color, then used the F4 keyboard shortcut to fill cell D2.
So if you’ve just changed the background color of a cell, you can use this shortcut to fill the next cell. The F4 keyboard shortcut You can use F4 to repeat the last action. You can add a new Fill Color icon on the first position in the Quick Access Toolbar. Quick Access Toolbar Theme Colors There is another, faster way to access Theme Colors. It won’t highlight a cell but will open the menu, where you will be able to choose your color with a mouse or keyboard arrows. In this method, you press Left Alt, release the button, then press the H button twice. Left Alt > H > H The first method is not the standard keyboard shortcut, rather a way to. Select current region around active cell.
#Keyboard shortcut for highlighting cells in excel mac#
Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side.
You can use keyboard shortcut without the shift key, but you have to remember that many shortcuts in Excel are, by default, assigned to other tasks. Highlight a cell with a keyboard shortcut. Below, are a few methods to achieve the desired effect.
But, as in many other cases, there are workarounds which will help you deal with this problem. If you are looking for a keyboard shortcut to highlight a cell with a color, I have a bad news for you, you won’t find any.