Mr. Modem: Get rid of email addresses that don’t compute

Posted Tuesday, Aug. 19, 2014  comments  Print Reprints

Mr. Modem’s Sites of the Week

For the Love of Monet

I remember first becoming enamored with Monet while I was living in Paris, working on my doctoral dissertation, “The Influence of the Renaissance Mime on Baroque, Neoclassicism French Architecture,” during the summer of ’67, I think it was. It’s all a little hazy. This site is fairly slow loading, so to go directly to the art, check out the Gallery, which features the art of Monsieur Monet, organized by the year of each work.


Interior Desecrations

An unflinching examination of unlovely, unattractive and unforgivable homes of the 1970s, complete with shag carpeting, harvest gold appliances and lava lamps. What’s not to love? So put on your leisure suit and click the links, starting with “1971: A Sample” and behold life as we once knew it.



If you’re a crossword puzzle enthusiast, here you can select easy puzzles or L.A. Times crosswords, as well as other word-related games. In the likely event you get stuck, stymied or flummoxed, click the “Solve” tab or button to reveal a letter, a word, or the solved puzzle. A little timer in the upper right-hand corner is informative, humiliating and stress-inducing. Enjoy!

Have more to add? News tip? Tell us

When I compose an email using Outlook 2007, the computer remembers the address, which is fine under normal circumstances. If I accidentally enter an incorrect address, though, it is also remembered. How can I remove any incorrect addresses?

When the auto-completion list of addresses appears as you type an address, press the Down arrow until the incorrect address is selected, then press DELete. If the auto-completion list does not appear, you are not out of luck and can access the underlying auto-complete file.

For a detailed, escorted walk-through of this process, review “How to reset the nickname and the automatic completion caches in Outlook,” at

My home router and anti-virus protection were installed by my local telephone company that also provides my Internet access. Does that mean I can be sure that my existing security is safe?

You can be reasonably sure, though there are never any guarantees with something like this. If you feel that your telephone company/Internet access provider employees are generally competent in the work they perform — no, seriously — then it is not unreasonable to assume that they did a good job and secured your system properly.

If, however, you are having second thoughts or are anything less than confident in the work they performed, I would suggest having a reputable computer repair person or service take a look at your setup and your system’s overall security.

Having a knowledgeable, independent person review the router installation and attendant security and make recommendations, if warranted, might be worth the price, if nothing else, for your own peace of mind.

I’m secretary of my homeowners’ association and need to create a list of numbers from 1 to 300. We have Excel, the spreadsheet program. Is it possible to create this list within Excel, but without having to manually enter each of the 300 numbers?

What you are describing is called a unique series of numbers and it is quite easy to do. Enter the numeral 1 in Cell 1A. Then, in Cell 2A enter “=a1+1” without the quotes. This will place the numeral 2 in Cell A2.

Next, click the little black square in the lower right corner of Cell A2 and drag it to Cell A301. Your cursor will change into a little cross when dragging. When you release the mouse button, you will have your list of unique numbers, 1 through 300. This will also work in OpenOffice Calc.

Mr. Modem publishes “Ask Mr. Modem!” each week, featuring PC tips, tricks and plain-English answers to your questions by email. For more information, visit

Looking for comments?

We welcome your comments on this story, but please be civil. Do not use profanity, hate speech, threats, personal abuse or any device to draw undue attention. Our policy requires those wishing to post here to use their real identity.

Our commenting policy | Facebook commenting FAQ | Why Facebook?