pctoolbox.co.uk

Today’s quick tip is the penultimate of the Shortcut Series.  Our category this week is Microsoft Outlook Shortcut Keys.  We think that it is worthwhile remembering a few of these shortcuts because they are bound to come in useful!  Please Note: Some shortcuts may not work in Outlook 2007.

Microsoft Outlook Shortcut Keys:

Alt + S – Send the email
Ctrl + C – Copy selected text
Ctrl + X – Cut selected text
Ctrl + P – Open print dialog box
Ctrl + K – Complete name/email typed in address bar
Ctrl + B – Bold highlighted selection
Ctrl + I – Italicize highlighted selection
Ctrl + U – Underline highlighted selection
Ctrl + R – Reply to an email
Ctrl + F – Forward an email
Ctrl + N – Create a new email
Ctrl + Shift + A – Create a new appointment to your calendar
Ctrl + Shift + O – Open the Outbox
Ctrl + Shift + I – Open the Inbox
Ctrl + Shift + K – Add a new task
Ctrl + Shift + C – Create a new contact

Next week is the last of the Quick Tip Shortcut Series.  The Shortcut topic will be Winkey Shortcuts

Disclaimer: pctoolbox.co.uk cannot be held responsible for any problems that are caused from using the shortcuts.  All shortcuts work to the best of our knowledge.

Week four of the Quick Tip Shortcut Series.  This week we have Excel Shortcut Keys.  We think that it is worthwhile remembering a few of these shortcuts because they are bound to come in useful!  Please Note: Some shortcuts may not work in Excel 2007.

Microsoft Excel Shortcut Keys:

F2 – Edit the selected cell
F5 – Go to a specific cell
F7 – Spell check selected text and/or document
F11 – Create Chart
Ctrl + Shift + ; – Enter current time
Ctrl + ; – Enter current date
Alt + Shift + F1 – Insert new worksheet
Shift + F3 – Open the Excel formula window
Shift + F5 – Bring up search box
Ctrl + A – Select all contents of worksheet
Ctrl + B – Bold highlighted selection
Ctrl + I – Italicize highlighted selection
Ctrl + C – Copy selected text
Ctrl + V – Paste
Ctrl + D – Fill
Ctrl + K – Insert Link
Ctrl + F – Open find and replace options
Ctrl + U – Underline highlighted selection
Ctrl + Y – Underline selected text
Ctrl + O – Open options
Ctrl + N – Open new document
Ctrl + P – Open print dialog box
Ctrl + S – Save
Ctrl + Z – Undo last action
Ctrl + F9 – Minimize current window
Ctrl + F10 – Maximize currently selected window
Ctrl + F6 – Switch between open workbooks/windows
Ctrl + Page Up + Page Down – Move between excel worksheets in the same document
Ctrl + ‘ – Insert value of above cell into current cell
Ctrl + Space – Select entire column
Shift + Space – Select entire row
Ctrl + W – Close Document

Next week our topic is Microsoft Outlook Shortcut Keys!

Disclaimer: pctoolbox.co.uk cannot be held responsible for any problems that are caused from using the shortcuts.  All shortcuts work to the best of our knowledge.

You may find that your AVG Anti-Spam isn’t catching some of your SPAM Emails.  If this is the case you will need to train AVG.  You may have to do this a few times but AVG catches on pretty quick!

1. First of all open up your email program e.g. Microsoft Office 2007 (Although we are using Microsoft Office Outlook 2007 for the example, the process is very similar in most email software.)  Now you must create a new folder.
   
2. Give the New Folder a name.  We suggest ‘TRAIN_SPAM’.  Then Click OK.
   
3. Drag into this new folder any Spam emails that AVG has missed.
4. Once you’ve put any missed spam in the folder you need to open up AVG.  Select ‘Tools’ and then ‘Advanced Settings’.
   
5. Click ‘Anti-Spam’, Settings and then ‘Train Anti-Spam’.  (Click on image to make bigger).
   
6. Select your Email Software from the list.  (Click on image to make bigger)
   
7. Now you will be asked for your profile name.  For most people there will be only one option because you will only have one profile.  But for those who have more make sure you select the right one, i.e. the one you will to train with.  You can make your selection via the drop down list.  Then Click OK.
   
8. Find the folder which you wish to train.  Then click ‘Next’.  (Click on image to make bigger)
   
9. Select All Messages (No Filtering) then Next.  (Click on image to make bigger)
   
10. Click Next.
11. Once the process is complete click ‘Finish’ and then ‘OK’.
12. Go back into Outlook or your email program and delete anything that was in the TRAIN_SPAM folder.

From now on the files like those that were in the TRAIN_SPAM folder should be sent automatically to your junk email folder. Sometimes they need to be trained a few times as there are variants of Spam so just repeat the steps above. Give it a go and let us know if you have any suggestions!

Everyone likes a quick solution to something, so on Pc Toolbox we are going to start publishing a Quick Tip every Friday Morning. Something that just makes using our favourite applications easier and maybe even more enjoyable!

If you have got a tip you would like us to publish (with credit to you of course!) please drop us an email with your Tip, Name, Email and Website Address!

Happy New Year!