Thursday, March 31, 2011

Quickly locate information on a web page by using the “FIND” option!

If you open a webpage and can’t easily find the information you want, use the “Find” option to quickly locate key words on the web page you are viewing.



1. View the webpage with Internet Explorer.


2. Click “Edit” (from the Menu bar) and then “Find on this page”, or press Ctrl+f to open the “Find” search box.


3. Type a key word into the box.


4. Press ENTER on your keyboard.


5. If a match is found, the word will be highlighted on the page.  The number of matches found will display to the right of the search box.

In the screenshot below, "training" was typed in the Find box.  Training is highlighted at the bottom of the webpage.



Tuesday, March 1, 2011

Quickly Select Large Amounts of Data with the Control Key

The Control key on your keyboard allows you to quickly select large amounts of data in Microsoft Word or Excel.  Here's how:

To select the entire file:
  • In Word, open the document, press and hold the Ctrl key, and tap the letter A.  Release both keys (Ctrl+A). The entire document should be selected. 
  • In Excel, if all your data is consecutive, click anywhere inside the data BEFORE pressing Ctrl+A.  This selects only the data and not the remaining blank cells.  If you click in a blank cell outside your data and then press Ctrl+A, the entire worksheet is selected.
To select part of the file to the end:
  • Open the file, click your mouse where you want to begin the selection, press and hold the Ctrl and Shift keys together, and tap the End key.  Release all 3 keys (Ctrl+Shift+End).
The method above works in both Word and Excel, but if you don't want to select all columns in Excel try this:
  • Select the beginning row of data over to the last column you want to include.  If you only want to include 1 column, select the beginning cell.  Press Ctrl+Shift+↓ 
EXAMPLES:
Your Excel spreadsheet has data in columns A - F and rows 1 - 2000.
  • To select all the data from A1:F2000, click in cell A1 and press Ctrl+A.
  • To select the data in cells A2:F2000, click in cell A2 and press Ctrl+Shift+End
  • To select only the data in column A, click in cell A1 and press Ctrl+Shift+↓ 

Tuesday, February 1, 2011

Use the CTRL key to Copy

The Ctrl (control) key on your keyboard has many functions. Use it with your mouse to copy text or pictures in MS Word, or cells of data in MS Excel.


It works in most Microsoft Office programs!  Here's how:
  1. First select (highlight) what you want to copy.
  2. Press and hold the CTRL key on your keyboard.  (There are two CTRL keys. It doesn't matter which one you hold.)
  3. Click and drag the selected item with your mouse to another location on the screen while holding down the CTRL key.
  4. Next release the mouse and CTRL key.  A copy of the selected item will appear leaving the original intact.
TRY IT!

Saturday, January 1, 2011

System Restore

With so many people experiencing computer problems, I want to remind you of a Windows tool that will return your system files and settings to an earlier point in time when your computer was working properly, without affecting personal files or email.



For example, if you have just downloaded a new program OR your computer automatically downloaded updates and now your computer isn’t working properly, you can use “System Restore” to restore your computer back to the way it was BEFORE the updates.


“System Restore” is available in Windows XP, Vista, and 7. 

Follow the steps below to run System Restore:


  1. Locate System Restore on your computer.
    1. In Windows XP or VISTA- Click START > ALL PROGRAMS > ACCESSORIES > SYSTEM TOOLS > SYSTEM RESTORE.
    2. In Windows 7 - Click START and then Type "SYSTEM RESTORE" in the search box.  Click SYSTEM RESTORE.
  2. The SYSTEM RESTORE wizard opens.
  3. Follow the instructions in the wizard.
  4. Allow ample time for your computer to restore to a previous restore point.
Notes:
  • If restoring your computer to a previous point in time does not resolve your computer problem, you can reverse the system restore back to the current settings.
  • System Restore does not affect your personal files or email.

Wednesday, December 1, 2010

Reopen Last Browsing Session

Did you know that Internet Explorer version 8 remembers the last webpage (or open tabs) that you were viewing when you closed your browser?  So if you accidentally close your browsing session, you can quickly return to it when you reopen Internet Explorer by following the steps below:
  1. Open Internet Explorer (version 8).
  2. From the Menu bar or Toolbar, click Tools> Reopen last browsing session.



Monday, November 1, 2010

Easily Switch Between Web Pages Using Tabs

If you’d like to keep a web page open while viewing a different webpage, just open each web page in a separate tab using Internet Explorer.
  1. First, open a webpage you wish to view (using Internet Explorer).
2.  Next, click on the blank tab (to the right of the tab you are currently viewing.)
3. A new tab appears. In the address bar, type the address for the next website you wish to view and press ENTER.

4.  Now you will see two tabs displaying the name of each website.  Click the tab for the website you wish to view.
5.  Repeat steps 2 & 3 to open additional tabs.
6.  To close a single tab, click the tab and then click the "X" on the tab.

Friday, October 1, 2010

Use Print Preview to Shrink a Microsoft Word Document

If your Word document is just a few lines too long to fit onto one page, you can use a command on the Print Preview window to quickly shrink the document to 1 page. This command is available in Word 2002, 2003, and 2007. In 2010 the option is not available in the new Print Preview (on the File tab); however, you can customize the ribbon and add the command “Preview and Print” to a new or existing group.

1. To shrink your Word document to 1 page, open Print Preview.

    Shortcut: press & release the following keys simultaneously: Alt+Ctrl+I (for Word 2010 you will have to select the Preview and Print command after you add it to the ribbon.)

 2. Click the command:

  •  Shrink to Fit (Word 2002 -2003)
  • Shrink One Page (Word 2007 – 2010)

 Note: If your document is too long for Word to shrink it, a message will display: