So this week’s Excel shortcut tweets turned out to be a celebration of F11:


Insert a new worksheet             SHIFT + F11

Delete the current sheet             ALT + E then L

Activate Chart tool / wizard        F11

Open VBA Editor                       ALT + F11


You may wonder what CTRL + F11 does. This inserts a new macro worksheet which is a relic back of the Excel4 days. Yes almost 20 years since Excel 4, when macros were written in a particular worksheet rather than the VBA editor, this shortcut still exists. As far as I know the new worksheets (titled Macro1 etc) don’t have any real use apart from for compatibility with the older version, unless you know to the contrary? Leave me a comment below as I’m intrigued if they’ve other uses.