Excel Shortcut: Open VBA Editor's Immediate Window

Ah the number of time's you've hoped that the VBA Editor's Immediate window could be attached to Excel's own window. That's not going to happen soon I think, so here's a tip how to quickly open and activate the Immediate window with some shortcut keys:

Alt + F11 Ctrl + G

Alt + F11 opens VBA Editor and Ctrl + G activates the Immediate window. Convenient way to help your spreadsheet editing especially with short single-line macros.

Excel Shortcut: Add Date or Time to Cell

To quickly add current date to active cell press CTRL + SEMICOLON (i.e. CTRL + ; )

To add current time press CTRL + COLON (i.e. CTRL + : )

Excel Shortcut: Open Save As.. Dialog

To open the Save As... dialog press F12

Excel Shortcut: Select Entire Worksheet / Select All Data

If worksheet contains data, Ctrl + A selects the current region. To select entire worksheet press Ctrl + A a second time.

Excel Shortcut: Select Entire Column

To select the entire column in Excel, select cell in that column and press Ctrl + Space

Excel Shortcut: Open VBA Editor

To quickly open VBA Editor window press Alt + F11

Excel Shortcut: Insert Comment or Edit Existing

To insert a new comment or to edit an existing one, select the cell and press Shift + F2