Keyboard Shortcuts

KEYBOARD SHORTCUTS

CTRL+Backspace

Go Back

CTRL+plus/minus

Zoom In/Out

Alt + 26/27

Insert Arrows 

→  ← 

Wait!  Where was I? In Excel, If you click on a cell, and then you scroll down to find something and want to go back to where you were, Ctrl+Backspace will do just that!

I Can’t see what I am working on!  Make the windows on your screen larger by hitting Ctrl + several times until it is the size you need it to be.  Want it back to where it was?  Just hit Ctrl – a couple of times.

Want to insert an arrow?  Simply hit Alt 26 for a right arrow →, or an Alt 27 for a left arrow ←

Help in Excel, Word and Outlook

EXCEL	WORD	OUTLOOK
Clicking and dragging a formula down a column is easy!  This process can be tedious if you have hundreds or even thousands of rows of data.  Whether it is 10 rows or 10,000 rows, if there is data on the left or right of a formula you are about to copy, just double click the auto fill handle.  The way you know you are on the AutoFill handle is that your cursor changes from a white plus to a black plus.  The formula will stop copying where your data stops.  You can also copy cells contents by just clicking (with the black plus) and dragging down to a selected cell, if there is no data in the neighboring cells.	Keep repeating the same information over and over?  Do you always close with the same few lines in your letters or often insert similar requests for information?  Create your own Quick Part and repeat your actions with a couple of clicks.  Type in your verbiage and select it.  On the insert tab, in the text group, click Quick Parts.  Select the last option, Save Selection to Quick Part Gallery.  To use it again, simply click the same button.  Your own Quick Parts should show up at the top of the drop-down menu.  Hint:  This works in Outlook too!	Follow up with Outlook. Set a follow-up flag BEFORE you send an email by using the message tab, which appears in place of the Home tab when composing email. Click on the drop down button of the Follow Up tab. Select one of the preset follow-up times or a custom date.  You can even set a reminder.  It will then show up as a task on your To-Do Bar.  You will get a pop up reminder when it is time to send a follow-up.

The Help Desk

The Help Desk

GETTING HELP FROM TECHNOLOGY

Q Are there things I can do when I am having troubles with my computer to help the technicians and speed up the process at the same time?

A There absolutely is!  The sooner that a technician can actually see what is going on, the faster they will be able to trouble shoot that problem for you.  Here are a couple of things you can do:

1. Error Messages: Copy and paste any error message that comes up on your screen and email it to one of our techs.  Those error messages that pop up are more than just annoying, they acutally contain a lot of very important information as to what is happening with your computer. 

2.  Print Screen:  Our techs can figure out a lot about what is going on by actually seeing what you are seeing, not just getting a description of what you are seeing over the phone or through and email.  There are a couple of ways to do this:
            A.  On your keyboard, to the right of your F12 key, there is a key that will say PrtScr.  By hitting that button, it serves as a “copy” so you will need to open up an email and do either a right click “paste” or do keyboard shortcut Ctrl V. 
            B.  If you don’t want to copy and paste your whole computer screen (desktop and all), you can do a screen shot just of your open window.  You can accomplish this by hitting Alt+PrtScr. 

Don't Be a Mouse Potato!

DON’T BE A MOUSE POTATO!

Most computer users can’t imagine working without a mouse. Think about the time you spend:

• Removing your hand from the keyboard, placing it on the mouse

• Refocusing on the screen and navigating where you want to position the mouse to click it

• Removing your hand from the mouse, replacing it on the keyboard

• Refocusing on the screen and performing the action.

Instead, let’s take a look at the time you can save with Alt key shortcuts.

Office 97-2003

Press the Alt key in Office 2003 and earlier versions and notice that a box appears around the word File. Do you also notice the underline under the letter F in File? All you have to do to drop down the menu is type the letter F. So, press the Alt key and then type F to drop down the File (or W to drop down Window or O for Format). Now, without the Alt key, type any letter in the menu. So, when you type Alt, F, O you get the Open dialog box. Switch files easily by typing Alt W and then 1, 2 or 3 to select the open file you want.

Office 2007-10

Don’t the menus disappear in 2007/2010? Yes, they do. But here is the great part about the Alt key shortcuts: Almost all of them will still work in the newer versions. For example, if you learn the Alt, E, S, V (Edit, Paste Special, Values) keyboard shortcuts in 2003, the same Alt key sequence works in 2007 and 2010, too. Here’s one more Alt key shortcut to try: Just tap the Alt key and notice what happens to the Ribbon. You’ll see a letter pop up over each tab and over each button in your Quick Access Toolbar. Now, tap one of the letter keys indicated over a tab, like the W over the View tab. Notice that now all buttons in the View tab have letters, as well. Just type the letter to perform this function.