Posts tagged hints
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.