In an almost unprecedented frenzy I blogged twice this week: once on wildcard searching in Excel, and also on finding out the day from a given date in a spreadsheet. As usual I tweeted a number of shortcuts which are as below, and was delighted to bump into someone this week who thanked me for tweeting the shortcuts, CTRL + K for hyperlink in particular. It’s good to know they’re being used! Here’s this week’s roundup:


Toggle Office Ribbon                  CTRL + F1

Find                                           CTRL + F

Replace                                     CTRL + H

Open Text to Columns Dialog      ALT + A then E

Select All                                    CTRL + A


That’s it for me, I’m off to London to revisit some old haunts frequented before our move to Shropshire. Have a lovely weekend!