Shortcuts Everyone Should Know

Keyboard shortcuts save you time – no need to use your mouse!

To use the following key combinations, press and hold the Control key on your keyboard while you press the letter key & then release all keys immediately. Do not hold down the letter key.

5 Microsoft Windows Shortcuts:

• Ctrl+a – selects all
• Ctrl+c – copies what you have selected
• Ctrl+v – pastes what you have copied
• Ctrl+p – opens the printer window
• Ctrl+s – saves your changes

10 Microsoft Word & Excel Shortcuts:  

• Ctrl+n - creates a new document or workbook
• Ctrl+Home (key) - moves the cursor/cell selection to the the beginning of the document or spreadsheet
• Ctrl+End (key) - moves the cursor/cell selection to the end of the document or spreadsheet
• Ctrl+f - opens the Find window to find data within the document or spreadsheet
• F7 (function key) - opens Spell Check
• Ctrl+e - centers the selected paragraph (Word only)
• Ctrl+enter (key)- creates a page break (Word only)
• Shift+enter (key)- moves cursor to next line without creating a new paragraph (Word only)
• Ctrl+; (semi-colon) - inserts today's date (Excel only)
• Ctrl+1 (number one) - opens the Format Cells window in Excel; changes line spacing of selection to single spacing in Word.

Change your Folder View for Pictures

When you are trying to find a specific picture on your computer, among many pictures in a folder, it is helpful to see a miniature of the picture along with its file name. You can change the View options to allow you to see a miniature of each picture. Here’s how:

 Windows XP
1. Open the folder containing your pictures (usually My Pictures).


2. Click the View menu or the Views icon on the toolbar and select Thumbnails to see your pictures.

Windows VISTA

1. Open the folder containing your pictures (usually Pictures).

2. Click the arrow next to the Views option on the top bar and select Tiles, Medium Icons, Large Icons, or Extra Large Icons to see different size miniatures of each picture.

Windows 7

1. Open the folder containing your pictures (usually Pictures Library).


2. Click the arrow next to the Views option on the top bar and select Tiles, Medium Icons, Large Icons, Extra Large Icons, or Content to see different size miniatures of each picture.

Get Rid of the "Enable Macros" Notice

Have you ever opened an Excel Workbook that no longer contains macros but it still prompts you to "Enable or Disable Macros"? 

Here's why:
When a macro is created, Excel adds a module to the workbook to store the macro.  When you delete all the macros in the workbook the module does not get deleted.
Note: A macro is a recording of a set of commands. Once a macro is recorded you can simply type the macro's name instead of typing the complicated sequence of commands, and all the commands automatically run that you have recorded.

How to delete the Module:

1. Open the Excel file that no longer contains the macro.
2. Press Alt+F11 (function key at top of keyboard) to display the Visual Basic Editor.
3. Near the upper-left side of the editor is the Project Explorer. This contains a hierarchical tree that shows the workbook name and the different modules in your workbook. If the Project Explorer is not visible on your screen, press Ctrl+R to display it.
4. Within the Project Explorer should be a folder called Modules. If it is not already open, double-click on the Modules folder to display its contents.
5. Right-click on a module in the folder. A menu is displayed. (See picture below.)
6. Choose the Remove option from the menu. You are asked if you want to export the module before removing it.
7. Click on the No button. The module is removed.
8. Repeat  steps 5 through 7 for each module in the Modules folder under your workbook name.
9. Close the Visual Basic Editor.
10. Save your workbook.

At this point your workbook contains no modules, and you will not get any notification when you subsequently open it.

Having difficulty reading the small print on the Internet?

If you are using a mouse with a scroll wheel, you can quickly zoom in on any web page to make it easier to read. 

Here's how:

• While viewing any web page, press and hold the Ctrl key (on your keyboard) while pushing the scroll wheel (on your mouse) away from you.  Pull the wheel towards you to zoom out.

If you don't have a mouse with a scroll wheel, you can use the Zoom option under the View menu of Internet Explorer.

Another helpful hint submitted by Cook Manwiller:


Use
Control and "+", (plus) to increase size
Control and " - " (minus) to decrease size
and
Control and " 0 " (zero) to return to normal size.

Tips for Printing a Web Page

When you print from the Internet you might be surprised at the results -- the page might be cut off on the right or too small to read. Web pages are NOT designed for printing. Some of the newer browsers automatically resolve this problem by shrinking the web page to fit on a standard 8 ½ x 11 page; however this can produce results where the print is very small and difficult to read.


Here are a few tips to improve your print results:

Look on the web page for a “printer-friendly” view and print from that view if it is available.

If a “Printer-friendly” view is NOT available and you are using Internet Explorer (version 7 or 8) to view the web, use the Print Preview option to make changes BEFORE you print. Print Preview allows you to see exactly how the web page(s) will look when printed and the number of pages that will print.

Click File from the menu bar and then click Print Preview. Use the navigation buttons at the bottom of the screen to scroll to view each page that will print.
If the text is difficult to read in Print Preview, change the direction of the paper to “Landscape” using ONE of these methods:
     -- Click the Landscape button on the toolbar

     -- Press ALT+L on the keyboard.

If the Print Preview is acceptable, click the Printer button on the toolbar to print the web page(s).

Having trouble opening Microsoft Word email attachments?

Office 2007 attachments have a different file extension than previous versions of Microsoft Office. (The file extension is the 3 or 4 letters after the file name, for example if the file is called "Test" and it is an older Word document, it would appear as: Test.doc where "doc" is the file extension.) 
Every file extension is associated with a different program so your computer knows what program to use in opening the file.
If you receive an email attachment with an “x” or an “m” at the end of the extension, it is probably a Microsoft Office 2007 file.
Example:


2007 Excel files end with: .xlsx or .xlsm (contains macros)

2007 Word files end with: .docx or .docm (contains macros)

2007 PowerPoint files end with: .pptx or .ppsx



If you are using an earlier version of Microsoft Office (i.e. 2000, 2002, or 2003) you will NOT be able to view Microsoft Office 2007 files, unless your computer has the Compatibility Pack for 2007 Office System (2007 file conversion add-on) downloaded. If you need this 2007 add-on, it can be downloaded from Microsoft.


IMPORTANT: Be sure to install all High-Priority updates from Microsoft Update before downloading the Compatibility Pack.

Computers that already have the Compatibility Pack for 2007 Office System will display it in the Add or Remove Programs under the Control Panel. (See screenshot below.)


To see if the Compatibility Pack is already installed on your computer, do the following:

Windows XP Users:


1. Click Start; Control Panel; Add or Remove Programs.


2. If you have Compatibility Pack for the 2007 Office System displayed in the list, you will be able to open Office 2007 files.

Internet Explorer - Create a Shortcut to a Website

Do you have a website that you like to visit frequently?

Create a shortcut on your desktop to quickly access any website.

Here's how:

1. Open Internet Explorer.


2. View the website for which you want a shortcut.


3. Click "File" from the menu bar and then select "Send" and "Shortcut to desktop".


4. Now close Internet Explorer and you will see a shortcut to the website on your desktop.


5. Double-click on the shortcut to open the website.

Here's an example of a shortcut to "CraigsList" :

Notes:

• You must be connected to the Internet for the shortcut to open a website.


• If the Menu Bar is not showing (version 8), right-click in a blank area of the toolbars and click "Menu Bar" from the list.