Tech Gazette

                              May 2003         

                 A Publication for SMES Faculty & Staff                                                                                                                                                                          Volume 4, Issue 9

  Table of Contents
  (clicking on an item takes you right to the feature)

Training Opportunities Setting the Print Area in Excel Finding E-Mail
Are Your Web Images Too Big? Viewing File Attachments Knowledge Hound
Consumer World Google Has Your Number Tech Assistance: 2003-4 Tech Requests

Training Opportunities

 

Outlook- Mailbox Management Wed., May 7 12:05 - 12:55

US Lab (lunch session)

Outlook- Mailbox Management

Wed., May 7 3:10 p.m.

US Lab

To reserve a place in either of these classes, email
         londa.posvistak@smes.org
        

Tech Tips: Working More Effectively

Setting the Print Area in Excel

If you work with Excel on a regular basis, clicking on the Print icon (or selecting Print from the File menu) will result in printing the entire worksheet. But sometimes, you only want to print a certain range of cells, not the entire sheet. In order to accomplish this, you need to set the print area.

First, you select the range of cells you want to print, then go to File| Print Area |Set Print Area. Every now and then, when you go to File| Print Area, you might accidentally click Clear Print Area instead of Set Print Area. Unless you undo that change right away, you'll have to reset your print range from scratch. Avoid accidentally clearing the print area by adding the Set Print Area button to your Standard toolbar.

Here's how to modify your Standard toolbar to include this button:

  1. Right-click on the Standard toolbar, choose Customize from the resulting menu, and click the Commands tab.
  2. Under Categories, select File.
  3. Locate the Set Print Area icon in the Commands list, click on it, and drag it to where you want it to appear on your Standard toolbar.
  4. When you release the mouse, the new icon will take its place on the toolbar.

To set the print area in the future, all you have to do is select the cells for the print range and click the Set Print Area button.

www.techrepublic.com

Finding E-Mail

What happens when the amount of our network storage space allocated to mailbox storage becomes critically low? The system goes down which is what happened on a recent Tuesday afternoon! Instead of saving mail in your Inbox, Sent and Deleted Items folders, you can find a specific e-mail one of two ways:

Sorting: When you're looking at your inbox, look at the column titles at the top (From, Subject, Received, etc.).

Simply click on the title you wish to sort by.

You should notice a little arrowhead appear in the title bar which indicates the direction of sorting. An arrow pointing up will sort messages ascending (A to Z or oldest date to newest). An arrow pointing down will sort messages descending (Z to A or newest date to oldest).

Find Feature: You can also conduct a search for a particular email in Outlook by using its Find feature. Just click on Tools, then Find (or Ctrl+E). In the Look For area, type in the name or keyword that is part of the email you're looking for. Then, in Search In, click on the down arrow and you can choose in which folders to search: the Inbox, All mail folders, Mail I Received, Mail I Sent, or specify a folder you've created. Click Find Now.

For other handy and helpful Outlook tips, take advantage of the training opportunities this month (Outlook Mailbox Management), and make a reservation!

Are Your Web Images Too Big?

When you end up on a web page with a gigantic picture, you can scroll up and down to see the entire picture, but there's a way to see the entire thing. As long as you're using the current version of Internet Explorer 6, you have an "Image Resize" component available to you! When viewing an image with Internet Explorer, it will automatically resize the image to fit in your browser. Now, this will NOT resize an image that's already embedded in a web page, it just works on regular images. Here's how to do it:

For non-linked images - If the image you're trying to see is NOT linked to another web page (i.e. if you click it and it doesn't take you to another page), just drag and drop the image to your Internet Explorer address bar. The image will be displayed all by itself and within the confines of your window.

For linked images - just right-click the image and select Properties from the resulting screen.

Double-click the address on the resulting screen to highlight it. Now, just copy and paste to the address bar. The image is there for the viewing.

Try it for yourself with this really neat picture: http://geocities.com/rop92027/iceberg.htm

Bonus Trick!

Here's another cool use for this tip. Say you have a graphic sitting on your desktop or in a folder (GIF or JPEG). You can open Internet Explorer and drag and drop the image to the address bar or main window - it'll pop right open. It's a great way to see an image without taking the time to open your graphics program.

www.worldstart.com

Did You Know?

Q: I want to send someone a MS Word file but I don't know if he has Office loaded on his computer. Will he be able to open this file if he doesn't have Office?
Q: My friend sent me an email attachment but I could not open it.

A: Nothing is worse than sending or receiving a file, and the program necessary to open it isn't loaded onto the computer! Here are some common file extensions and the programs needed to open them:

.doc - Microsoft Word; .pps - MS PowerPoint; .xls - MS Excel worksheet; .wpd - Corel WordPerfect; .pdf - Adobe Acrobat; .jpg - JPEG graphic file; .zip - Zip (compressed) file; .sit - Stuffit (compressed) file

The good news is that most software developers offer freeware viewers that will allow you to see, but not alter, content. NOTE: These addresses are long, so you may need to copy and paste into your browser if it breaks into more than one line.

               .doc - Microsoft Word Viewer
                http://www.microsoft.com/downloads/details.aspx?FamilyID=0e56d944-38f6-4eb5-aca6-8bd280d5e6b1&DisplayLang=en *

               .pps - PowerPoint Viewer
                http://microsoft.com/downloads/details.aspx?FamilyId=D1649C22-B51F-4910-93FC-4CF2832D3342&displaylang=en *

               .xls - Excel Spreadsheet Viewer: http://office.microsoft.com/downloads/2000/xlviewer.aspx*

               .wpd - Wordperfect:  Corel no longer offers a viewer

               .pdf - Acrobat Reader:  http://www.adobe.com/products/acrobat/readstep2.html

               .jpg - You can view these in your web browser or most imaging software.

As for compressed files (.zip & .sit), Stuffit Expander is a great program that will open most compressed files: http://www.stuffit.com/expander/. There are also a million freeware/shareware programs for opening .zip files such as WinZip.   http://www.winzip.com

In addition, Windows XP has its own built in unzip program.

So, next time you get an attached file in your email but don't have the program to open it, just grab a viewer.

*At the Download Center, in the Search for Downloads section in the center of the page, use the Products and Versions drop-down list boxes to choose your product and version. Select the Converters and Viewers check box and click Update List.

www.worldstart.com

Knowledge Hound

Have you ever wondered what it takes to learn Eight Step Praying Mantis Kung Fu? Or perhaps you want to know how to protect your finances in this economy. Maybe you're just curious about building a tetrahedron kite. Well, here's the website for you!

Knowledge Hound claims to be the Web's biggest directory of free do-it-yourself tips and tutorials from sports to cooking to computers and much, much more. Take a look at some of the links offered.

http://www.knowledgehound.com/

Consumer World

It's that time of the year to think about presents (graduation, wedding, goodbye), college items, household goods, etc. We all want to get the best prices for the best quality of goods. Consumer World is a public service, non-commercial guide cataloging over 2000 of the most useful consumer resources. You'll find information about products as well as the latest news at this site.

To see what you think, click here to go to the site:

 http://www.consumerworld.org/

Google™ Has Your Number

Google is an amazing search engine but did you know that it has the ability to conveniently look up information from the White Pages of any telephone book? Just type in your (or another) phone number into the search bar [area code-xxx-xxxx, no parenthesis] and click on "Google search". If the number is listed, a name and address will pop up. As an added feature, Google includes a couple of mapping services in case you want to look up the location. Now, this is a great feature if you want to find out where and how to get to that great restaurant you've heard so much about, but you may not want your personal information so readily and conveniently available. If this is the case and you don't wish for your information to be available through Google, you can click the telephone icon next to your information and it will be removed.

www.google.com

Technology Assistance

Did you remember to fill out a request for any technology need in the 2003-2004 year? In Lynn Ozonian's April 4th email, the 4/17 deadline (before you left for Spring Break) has passed, but there may still be a little more time. Use this link to fill out and submit your request asap:     

http://www.smes.org/technology/request2003.asp

If you need help with technology, call the helpline at ext. 697 or email help@smes.org .
              
Provide as detailed description of the problem as you can, and include the best times for someone to come by.

St. Margaret's Episcopal School ~ 31641 La Novia Avenue ~ San Juan Capistrano, California  92675
St. Margaret's Main Page