It Displays the drop-down menu for the corresponding smart tag. Inserts a new worksheet into the active workbook Insert Chart (It Creates a chart of the data in the current range)ħ. ALT + SHIFT + Function Keys Shortcut Shortcut Key Maximize or restore currently selected workbook windowĥ. SHIFT + Function Keys Shortcut Shortcut Keyĭisplays formula box to Paste function into the formulaĦ. ALT + Function Keys Shortcut Shortcut Key Minimize currently selected workbook window It will Unhide the rows in the current selectionĤ. CTRL + Function Keys Shortcut Shortcut Keyĭisplay Print Preview area on Print tab of Backstage ViewĪlternate between the currently active workbook window and the next workbook windowĪpply Move command on the active workbook windowĪpply Resize command on the active workbook window It Selects the current region (associated by blank rows and columns) It Enters the value from the cell directly above into the active cell It Unhides the columns in the current selection. Please note that I am an affiliate of Jon’s course and receive a portion of any sales generated with the above links.It is also used to switch between absolute/relative refs It’s a deep topic – dark, ocean blue (see what I did there?).Īnd for VBA, I suggest my friend Jon Acampora’s VBA Pro Course. This technical documentation from Microsoft has all the gory details of how colors in Excel work. This exercise takes advantage of Excel’s color system and VBA. This one-line macro code saves me lots of time when I’m marking up my worksheets, and I hope you can use it too.
When I hit that keystroke, I get a green cell.
Select Options and type your keyboard shortcut.įor example, I assigned Ctrl + Shift + G to the Green macro. To assign keyboard shortcuts to the macros you created, go to Developer | Macros and select the pertinent macro (Red, Yellow or Green). Simply click to Developer | Visual Basic and paste the below code into a module under your Personal.XLSB workbook. Wouldn’t it be great to just make our own keyboard shortcuts to fill cells? For example, Ctrl + Shift + R, and our selection is filled red, and so forth.
It requires precise, time-consuming, pointing-and-clicking from the mouse. One thing we can all agree on, though, is that filling cells from from the home ribbon is annoying. And maybe you have your own (please leave it in the comments!). Yellow means either neutral, or that I haven’t decided yet! Red cells indicate I need to take action on something, while green means all systems go. When exploring a workbook, I like to color-code cells so that I remember what I need to do with that information.