Management information specialist and Excel detective
Posts tagged twitter
Microsoft Excel Shortcut Tweet Roundup w/c 10th October
Oct 14th
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!
Microsoft Excel Shortcut Tweet Roundup w/c 3rd October
Oct 7th
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.
Microsoft Excel Shortcut Tweet Roundup w/c 26th September
Sep 30th
Another Friday, another round up of my Excel and other Microsoft Office shortcut related tweets for the week in case you missed them:
_____________________________________________________________________________________
Add in a hyperlink CTRL + K (works across the Office platform)
Save As F12 (see my blog post here on why I think it’s one of the most useful shortcuts)
Enter the Current Date CTRL + ;
Enter the Current Time CTRL + SHIFT + ;
_____________________________________________________________________________________
I also retweeted a nice solution from Tom Urtis on how to remove mutiple hyperlinks in a spreadsheet in a few keystrokes and then blogged about how the VBA works here.
Any suggestions for Excel (or indeed other) tasks that you’d like to know a shortcut for then just leave me a comment below.
Microsoft Excel Shortcut Tweet Roundup w/c 19th September
Sep 23rd
Autumn is here and in between turning produce from the allotment and hedges of shropshire into soups, chutneys and other harvest delights I’m going to start back tweeting Excel shortcuts. Hopefully these shortcuts, along with other hints and tips I’ll blog / tweet about will give you some ideas as to how you can streamline your work and make Microsoft work for you. A roundup of tweets I’ve previously made is here, but this week I covered:
_____________________________________________________________________________________
Selects the entire active row SHIFT + SPACEBAR
Selects the entire active column CTRL + SPACEBAR
Undo! CTRL + Z (NB: Very handy and works across microsoft office programmes)
Redo CTRL + Y
Opens the format cells dialog box CTRL + 1
_____________________________________________________________________________________
Any suggestions for things that you would like to see then please do get in touch leaving a comment below.
Microsoft Excel Shortcut Tweet Roundup w/c 1st August
Aug 5th
This week’s shortcut tweets were
_____________________________________________________________________________________
Enter current date CTRL + ;
Open pivot table wizard ALT + D then P
Sort data ALT + D then S
Move between tabs in a workbook CTRL + PageUp or CTRL + PageDown
Open Spellcheck F7 NB: this works in other Microsoft Office products too, such as Word, Outlook and Powerpoint
_____________________________________________________________________________________
There will be more next week, but in the meantime what are your favourite shortcuts?