Keyboard Shortcuts
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?
Microsoft Excel shortcut round up
Jul 29th
Periodically I post on twitter some handy keyboard shortcuts for Microsoft Excel. I am going to try and make this a more regular occurance with weekly roundups, so in case you’ve missed those I’ve tweeted so far, here they are:
_____________________________________________________________________________
Add a border around selected cells CTRL + SHIFT + &
Remove a border from selected cells CTRL + SHIFT + _
Add a comment to a cell SHIFT + F2
Hide a row CTRL + 9
Unhide a Row CTRL + SHIFT + (
Hide a column CTRL + 0
Unhide a Column CTRL + SHIFT + ) NB: if you’re using Windows Vista or Windows 7 this probably won’t work. See here for why and a way to get around this
Convert selected cell to a currency format CTRL+SHIFT+$ NB: this coverts to the default regional setting, so if you’ve UK settings will be £ despite the $ used in the shortcut!
_____________________________________________________________________________
I hope you find these useful, I’ll continue to post them regularly but what’s your most used keyboard shortcut? Let me know in the comments below.