Next Technology

This article offers a description two features which are very useful when printing worksheets in Microsoft Excel: Print Titles and Set Print Area.

Print Titles

Each time you print a worksheet, Excel normally prints all the data that it contains. However, there are times when you only want to print a selection of your data. Although you can achieve this by hiding rows and columns, Excel offers a simpler solution.

For example, let’s say you have a worksheet with only five average-sized columns but several hundred rows, although the header and footer appear on every page, only page 1 will have column headings. This means that it becomes difficult to know what the figures on the other pages relate to. We can make use of Excel’s Print Titles feature to print the column headings on every page. Print Titles are in the Page Setup section of the Page Layout tab; simply click on the button and Excel displays the Page Setup dialog box with the Sheet tab activated. In our five column worksheet example, we would only need to specify the number of rows that we want to repeat at the top of every page. In our example, it would be only the first row. Having clicked to specify row one, we can click Print Preview to see the result and we would see that the headings are repeated at the top of each page.

Only one print area can be specified at a time. The Clear Print Area command will restore normal behaviour; so that, when you print, the entire worksheet will be printed.

When you print a worksheet, Excel normally prints all the data that it contains. However, there are times when you only want to print a selection of your data. Although you can achieve this by hiding rows and columns, Excel offers a simpler solution.

In the Page Layout tab of the Excel 2007 ribbon, you will find the Set Print Area drop-down menu. When you click on it, it offers two options: Set Print Area and Clear Print Area. The Set Print Area command allows you to highlight a range of data and specify that this is the only part of the worksheet that will be printed whenever you use the print command. Having chosen the Set Print Area command, Excel will now display a dotted lined border around the area that has been set, in much the same way as it normally displays the page boundaries after the print command has been used.

Only one print area can be specified at a time. The Clear Print Area command can be used to restore normal behaviour; so that, when you print, the entire worksheet will be printed.

Author is a developer and trainer with On-SiteTrainingCourses.Com, a UK IT training company offering XML and XSLT Classes in London and throughout the UK.

Most computer users in the United States have heard of the leading American antivirus vendors. Manufacturers such as Symantec, McAfee, Computer Associates, and Trend Micro. These companies have a market leading presence in the United States. Microsoft, too, has aspirations to become a key player in this enormous growth market.

In fact, Microsoft bought intellectual property and technology rights from GeCad software in 2003, a company situated in Bucharest, Romania. They also acquired Pelican Software, which had a behaviour orientated security product, as well as the Giant Company Software for spyware and Sybari Software, which controlled virus, spam, and phishing filtering.

A great deal of discussion centered on whether Microsoft would end up in a domineering place in the antivirus market by simply bundling its recently acquired software technologies up with its Windows operating systems at no charge. This is a comparable technique that has been applied in other markets such as word processing and Internet browsers. In fact, this is precisely what did take place. Microsoft has come out with a free product called Microsoft Security Essentials.

It is too soon for me to advise whether MS Security Essentials is a world-class antivirus product, but it is not free to everyone. Microsoft has been battling Windows piracy for a while now with its Windows Genuine Advantage sneaky download and sure enough, this new product from Microsoft will only work on Windows systems and even then, only with operating systems that pass the Windows Genuine Advantage test. (Please click the link at the bottom the page to find out more).

There is nothing wrong with that per se, but it does mean that hardly anyone in the Third World will be able to make use of it, because a pirated operating system comes bundled with every computer that I have ever seen in Asia and probably elsewhere too. People save for years in order to afford a computer and the last thing they worry about when they plug it in is whether the operating system is genuine or not.

Of course there is a number of other antivirus manufacturers prominent in this market. There are many companies with great market presence in other countries that are beginning to become more widely recognized. These vendors include GriSoft from the Czech Republic, Sophos from the United Kingdom, Panda Software from Spain, Kaspersky from Russia, SoftWin from Romania, F-Secure from Finland, Norman from Norway, Arcabit from Poland, VirusBuster from Hungary, Nod from Thailand and AhnLab from South Korea.

It is not yet clear where the industry is heading and everyone in this market faces a rapidly changing scenario. The amount of effort required to find and deliver fixes for new viruses is quite staggering. Malicious programs are becoming more and more complex and the quantity of them is escalating.

Many companies may find themselves without the capital to equal the efforts of those truly bent on creating havoc. The antivirus companies are receiving hundreds of new samples of viruses a day! What is more, the new viruses are getting “smarter” in that they propagate themselves quickly and they often hide themselves too. Some are even smart enough to move around in a system by renaming themselves in an effort to make it difficult to remove them.

Owen Jones, the author of this article, writes on many subjects, but is currently involved with researching the Microsoft antivirus software. If you have an interest in such software, please go over to our website now at Computer Antivirus Software

Following are some tips for fighting spam:

Delete without opening the message: Opening the spam message can actually send a signal to the spammer that someone has looked at the on-screen message and therefore that the email address is valid-which means you’ll probably get more spams in the future. If you don’t recognize the name on your Inbox directory or the topic on the inbox subject line, you can simply delete the message without reading it. Or you can use a preview feature in your email pro-grim to look at the message without actually opening It; than delete it, (Hint: Be sure to get rid of all the deleted messages from time to time; otherwise, they will build up in your “trash” area.)

Never reply to a spam message: The following advice needs to be taken seriously: Never reply in any way to a spam message! Replying confirms to the spammer that yours is an active email address. Some spam senders will tell you that if you want to be removed from their mailing list, you should- type the word remove or unsubscribe in the subject line and use the Reply command to send the message back. Invariably, however, all this does is confirm to the spammer that your address is valid, setting you up to receive more unsolicited messages.

Opt out: When you sign up for or buy something online and are asked for an email address, remember to opt out of everything you’re sure you don’t want to receive. When you register for a website, for example, read its privacy policy to find out how it uses email addresses-and don’t give the site permission to pass along yours.

Enlist the help of your Internet access provider, or use spam filters: Your IAP may offer a (for example, Earthlink’s Spaminator and Hotmail) to stop the stuff before you doesn’t, you can sign up for a filtering ImagiNet (www.imagin.net) for a small Or there are do-it-yourself spam-stopping.

Fight back: If you want to get back at other Internet abusers-check with abuse.net (www.abuse.net) or Ed Falk’s Spam Tracking Page (www.rahul.net/falk), Spamhaus (www.spamhaus.org tracks the internet’s worst spammers and ISPs and law enforcement agencies to remove persistent spammers from the provides a free database of IP addresses spammers. These groups will tell you where to report spammers, the appropriate people.

Learn more about Scan Your PC. Stop by Author Name’s site where you can find out all about PC Toolsand what it can do for you.

Some electronic gadgets like cell phones, portable gaming systems, and laptops have screens that are fairly easy to scratch by the careless user. Even putting these items in your pocket can cause scratches, if you’re not careful enough. Likewise, when you drop these gadgets on the floor, you’ll be sure to have some scratches on them.

Careful users do their best not to acquire any scratches on their phones. However, even with utmost effort, plastic cell phone screens will still have scratches, one way or another. This is why screen protectors are so important, and the first thing you have to look for is the quality.

One side of the sheet is coated with a substance that causes it to stick to a plastic screen while the front merely contains the plastic itself. A person who buys these screens must cut the plastic to fit the shape of his or her cell phone. This is also true if he wishes to protect a PSP, a DS, or an MP4 player in a similar manner.

There is a need to cut these plastic screens to fit the shape of a particular cell phone. The same holds true for PSP, DS or MP4 player.

The most basic form of a cell phone screen protector simply protects the screen from scratches, but screen protectors that reduce glare help reduce eye strain and make the phone easily readable on sunny days.

A regular cell phone screen protector serves only as a shield from scratches. There are screens that offer more protection, and that is for the eyes of the users. This kind reduces shiny reflection that causes eye strain so it would be easier to read the messages even on sunny days. The more expensive screens are ultraviolet radiation resistant. Not that they protect the users’ eyes from ultraviolet rays, they simply have the resistance to last longer.

LG phones already have basic screen protectors with them, but it’s only to shield the phone from scratches. For those who wish to buy screen protectors that offer all the above features, an LG supply store can be a good stop. A reasonable cell phone protector should cost less than $25.00, unless bought in bulk.

Now you should go find the screen protectors that will fit you model of cell phone, computer screen, or laptop. The best phone screen protector would be thin, light, and not noticeable.