These are tips I have given and shared enough times that I thought it helpful to post for others.
If you have any tips to share, or need help, Please contact us. |
Click the link below to go directly to the topic.
|
Internet Tip - Auto http://www.***.com or http://www.***.net
Here is a faster way to enter an internet web address into a web browser address box.
1. Type the name of the website in the address bar, "crjwakeman" for example.
2. Hold the Control key down.
3. Press the Enter key. The browser will automatically insert - http://www.crjwakeman.com into the address box and enter the request. The web site will then load.
1. Type the name of the website in the address bar, "crjwakeman" for example.
2. Hold the Shift key down.
3. Press the Enter key. The browser will automatically insert - http://www.crjwakeman.net into the address box and enter the request. The web site will then load. |
Excel Tip - the Fill Handle
Fill in a series of numbers, formulas, dates, or other items using the Fill Handle in Excel to increment the series by a specified amount.
1. Select the first cell in the range you want to fill
2. Enter the starting value for the series. This can be a name for instance.
3. Select the next cell in the range
4. Enter the next value in the series. This can be another name.
The difference between the two starting items determines the amount by which the series is incremented.
5. Select the cell or cells that contain the starting values.
6. Position mouse over the Fill Handle.
The fill handle is located at the bottom right corner of the cell selector. The cell selector is the black frame surrounding the selected cell.
7. Drag the fill handle over the range you want to fill. Using the name example, Excel will repeat the two names over and over.
To fill in increasing order, drag down or to the right.
To fill in decreasing order, drag up or to the left.
This works great for filling in lists, dates, numbers, names, or any incremental value.
Top |
|
E-Mail Attachments
This is a common need. Read the Printing instructions below to print and use these steps.
First assumption is that you are going to be using Outlook, or Outlook Express. These steps will be similar but maybe not exact. If YOU (the reader) will take your time and read your screen and prompts, you will be able to make these steps work with ANY e-mail program. The steps are the same for every e-mail program. The buttons and names may be different.
1. Open your e-mail program.
2. Create a new e-mail, or do a reply to an existing e-mail.
3. Locate the Attach File button, or the Attachment button for your e-mail. Outlook displays a Paperclip for this button. This will open a Browse for file window, similar to an open file window.
4. Locate the file to attach to the e-mail. Files can be pictures, word, excel, or any type of file that is to be sent to another person. Be careful that the file is not too large. Some e-mail systems will not allow attachments over a certain size, usually 1 megabyte. Most large pictures will be around this size, try it anyway.
5. Click the Open or Attach or Insert button to complete the attachment process.
6. Send the e-mail.
Top |
Print Tips
Ever print something from the Internet? What you thought was one page was twelve because of all the graphics? Here is how to get around that!
1. Click and Drag using the left mouse button to highlight the text you want to print.
2. Press [Ctrl] + P on the keyboard.
3. Check the Selection bullet in the print range dialog box.
4. Click OK or press [Enter]
This will print only the highlighted text.
Top |
|
Zoom a Web Page
Reading a web page and need the text to be bigger? Try This!
1. Make sure you are viewing a web page on the Internet
2. Hold the [Ctrl] key down
3. Roll the mouse scroll wheel back and forth
Watch the screen while you do this.
NOTE: This does not work on every web page. It does work here!
Top |
|
Internet Navigation
This tip qualifies as a keyboard shortcut. We have taught this to many people and always get the same response: "Wow! I did not know that!". Most people to back-up on the internet use the Back button. This is a faster alternative.
After visiting a web page use the Keyboard as follows:
1. Press and hold the [Alt] key,
2. Press the left arrow [<-] button.
Top |
Access Tip
Access does not provide a method to center a heading on a Form. Follow this general guide to get around this situation. Doing so will make your Forms look better.
1. In the design view for any selected form, place your label placeholder at the top of the form.
2. Click and drag the label placeholder handles to the extreme sides of the form.
3. On the format toolbar, Click the Center Align button.
Top
|
Cut, Copy, and Paste
These three functions will help in many computer uses. This can be used for everything from moving entire files, to adjusting and moving lines of text. All windows have these functions under the Edit menu. These functions can also be performed using the keyboard. Using the keyboard shortcuts is faster and many times more convenient. These functions use a memory function called "The Clipboard". Picture the old wooden clipboard most people have seen or used. The computer clipboard will hold only one item. That item can be a picture, a file, several pages of text, or one character. The functions of each are described below:
Cut: will remove a file from the present location, placing the item onto the clipboard, and will gray out the icon. Text will immediately be removed. Like using a pair of scissors to CUT the file or item out.
Copy: places a copy of the item on the clipboard, just like a copy machine.
Paste: places a copy of the item from the clipboard onto the current location of the cursor. (Pay attention to where the cursor is located)
Using the keyboard for these functions:
First highlight or select the item or text to cut or copy.
Cut: [Ctrl] + [X]
Copy: [Ctrl] + [C]
Paste: [Ctrl] + [V]
Top |
Word - Page Setup Properties
Microsoft has provided us with a fast way to open the page setup properties in Word.
Double Click in the gray area located to the left or right of the Ruler at the top of a page.
Top |
Importing Clip Art into Microsoft Office
Have you ever wanted to insert a picture into a document, and the Clip Art thingy gives you some message about the clip not being installed, and to put some CD in the drive? Follow these steps to install the Clip Art into your computer:
1. Click Insert Menu.
2. Select Picture.
3. Select Clip Art.
4. Click [Import Clips] button at top.
5. The open Dialog box will open.
6. Place MS Office CD with clip art in the CD Rom Drive.
7. Select the CD Drive in the "Look In:" drop down box.
8. Open the "Pfiles" folder on the CD by double clicking the folder.
9. Open the "MS Office" folder by double clicking the folder.
10. Open the "Clip art" folder by double clicking the folder.
11. Open any of the (I have nine) folders listed.
Each folder contains hundreds to thousands of pictures.
12. Click one left click on the first picture listed.
13. Scroll all the way to the end in the open window, hold the [Shift] key down, click one left click on the last picture in the folder. This will select all pictures.
14. Click the "Copy into Clip Gallery" under clip import option.
15. Click the [Import] button.
16. The import function will run for several minutes. If it asks you to type in a names for the clip art, Click on the "Mark all clips with the same properties" check box.
17. Click [OK].
18. You have successfully imported a folder full of Clip Art.
Top |
Using the Internet? (Read This)
Most users or web surfers use one screen or browser window.
When needing to research or read something else they click a link, or navigate away from the original site. This creates a feeling of "I am lost", or "How do I get back to the original site?".
The solution to this is:
1. Open another Internet Explorer window or Netscape Communicator window.
2. Copy the address link from the original window.
3. Paste into the new Internet Explorer window or Netscape Communicator window address box.
4. Press enter on the keyboard.
Ta Dah!
You are now successfully utilizing your computer more efficiently.
Top |
Closing all Windows
When moving around within the windows environment, many time multiple windows are opened. To close all windows at the same time follow these simple steps.
1. Press and hold the [Shift] key.
2. Click the [X] button in the top right corner of the active window.
Top |
Creating Publisher Documents
If you use Microsoft Publisher to create documents, and you want to e-mail a document to a person that does not have Publisher.
How can you do this?
Fortunately Publisher and PowerPoint are both Microsoft products.
1. Create your document in Publisher
2. Click Edit menu
3. Select the Select all option
4. Press [Ctrl] and [C] on the keyboard to copy document
5. Open blank slide in PowerPoint
6. Paste copied material from clipboard
7. Save slide
8. E-mail this PowerPoint slide to the other person.
Top |
Function Keys
MicroSoft Office has a list of Function keyboard shortcuts. Print this list following the Print Tips below and keep on hand for quick reference.
Function Keys
See help for a complete listing.
F1 --------- Opens Help
F3 --------- Inserts Auto Text
F4 --------- Repeats last function
Alt + F4 ---- Close Program
F5 --------- Opens Find/Replace/Go To dialog box
F7 --------- Spelling and Grammar check
Shift + F7 -- Opens Thesaurus
F8 --------- Increase the size of a highlighted selection
F10 -------- Makes Menu Bar active
Shift + F10 - Opens custom shortcut menu
F12 -------- Performs Save As
Shift + F12 - Save to current location
Top |
Keyboard Shortcuts:
Recently experiencing monitor failure taught the value of knowing keyboard shortcuts. Below is a list of shortcuts to assist in saving, closing programs, and shutting down the computer.
Ctrl + S --- Save
Ctrl + W --- Closes file or document
Alt + F4 --- Close the Program (Close all open programs)
Alt + Tab --- Changes open program selection
After all programs are closed
Ctrl + Esc --- Opens Start menu
Press ^ (Up Arrow) on keyboard
Press > (Right Arrow) on Keyboard to select Turn Off
Press Enter to shut down computer.
After shutting down the computer proceed to your local computer store, like Warp Computers, and purchase a 17, 19 or 21 inch monitor. Monitor prices are low and dropping. A larger monitor can be purchased for less than what was paid for the original monitor. Then when you are blasting space aliens or developing that killer application you have more room to work.
Top |
Automatic Formatting
If you are like most people you get frustrated with MS Word constantly trying to automatically add numbers and bullets to lists and documents while typing. Admit it! You have been typing and had to stop and fix what the auto format did to the document. Here is how to stop that blasted thing from doing that.
1. Select Format menu
2. Select Auto Format.
3. Click Options button.
4. Select "Auto Format As You Type" tab at top.
5. Uncheck Automatic Bulleted Lists.
6. Uncheck Automatic Numbered Lists.
7. Click OK.
To enable the automatic Bullets and Numbers follow the above steps and place a check in step 5 and 6.
Top |
OutLook Tip
This came to me from a friend from High School Tom Petrik:
Chris, thought I would pass on something to you since you're the local computer guru. Last night, I had Outlook lock for whatever reason, and when I tried opening it, I received a message stating that the Outlook Navigation Pane could NOT open.
Do you know how to 'resolve' this?
I contacted Microsoft about it, and they said:
Click on Start>Run or Use key combo "Windows Key + R" to get the Run Prompt
Type in "Outlook.exe / resetnavpane" (keep the space btwn the "/")
Close and restart Outlook
Works like a charm, if NOT, you'll have to create a New Profile
Thought I'd share it with you since we're both pretty computer savvy and this one kicked my butt overnight.
|
