Announcements

Make Your Computer Run Great!

We all want to get the best performance out of our computers, right? Remember when you first brought yours home? Remember how wonderfully empty and uncluttered your hard drive was? Remember how much faster things seemed to before it was bogged down with lots of extra programs, internet temp junk, and various leftover files?

Well, we have a program that can help recapture your computer's youth - and more!

It's QuickClean by Mcafee and it's designed to help free up wasted disk space, find and delete unused files, completely remove unwanted programs, remove internet build up (temp files, cookies, etc), clean out old registry entries, and it even gets rid of "leftovers" from programs you've uninstalled! It was able to reclaim nearly 1 gig of HD space on our test machine! Wow!

That alone is enough to make this fantastic program a must have - but it gets even better. In addition to keeping your hard drive free from clutter, it also protects your privacy.

QuickClean can check your hard drive for spyware, delete internet history, remove items from the "most recently used" lists (like at the bottom of the File menu in Word), and more.

This program also includes an awesome file shredder utility that makes deleted files impossible to recover by a third party. You see, even when you delete a file and remove it from your recycle bin, it can still be recovered. In fact, I read an article in PC Mag a few months back that described how old data could be easily extracted from a hard drive that had been reformatted! It was some scary stuff.

With this program's file shredder, you'll never have to worry about that again. It takes the data and destroys it - permanently. Once shredded, it's gone and can't be recovered. Period.

I could go on and on about this outstanding software - it's really packed with features and I think it's something everyone can use.

Your price? Just $14.97 and US shipping is FREE! This is the current version of the software and it retails for $49.95 - so it's an incredible deal. Check it out:

http://www.worldstart.com/store/quick-clean.htm

PS - Quantities on this are very limited. This was part of a one time buyout and once these are gone, we can not get any more. If you're interested in this I urge you to get to the site ASAP.

MS Office 101

Shifty Highlighting

What's the first thing you need to do to format, move or copy text?

Why highlight it, of course.

Which, as we all know, is easy enough to do with the mouse—but for those of you who truly prefer the keyboard it's a pain.

A pain... until now that is.

The whole secret for highlighting with the keyboard is the Shift key.

The Shift key?

Yep—it's all in the Shift.

Here's a list of key combinations that will accomplish your highlighting needs.

• Shift + left or right arrow will highlight one letter.

• Shift + Ctrl + left or right arrow will highlight one word.

• Shift + up or down arrow will highlight one line of text.

• Shift + Ctrl + up or down arrow will highlight one paragraph at a time starting from the cursor's current location.

• In Excel: Shift + arrow will highlight one cell at a time - or, if used in combination, blocks of cells.

• Shift + Home will highlight from the cursor to the beginning of the line.

• Shift + Ctrl + Home will highlight from the cursor to the top of the document.

• Shift + End will highlight from the cursor to the end of the line.

• Shift + Ctrl + End will highlight from the cursor to the end of the document.

• Shift + Page Up or Page Down will highlight one screen.

Well... if you're new to the keyboard express then that's quite a list to learn, so I'll let you get to it.

Office Tip of the Day

Now Who Told Excel To Paste That Data?

Have you ever found yourself asking that question? (Or, in my case, asking the computer the question in my "I'm not amused, just annoyed" voice.)

You may have, especially if you work with hidden cells. (You know, hidden rows and columns with data in them that's necessary but not to be displayed.)

When you select a range of cells to copy that contain hidden data you get an unhappy surprise when you paste. The paste brings you both the visible and hidden data.

Now what?

Delete or re-hide the data, I suppose.

Sounds like a lot of extra work to me, how about you?

Yeah—I thought you might agree.

So the question begs to be asked: is there a way to copy / paste only the visible data?

Good question.

Fortunately, I've got a good answer for you.

Yes! There is a way to bring only the visible data in the paste.

(Happy dance time!)

I'm sure by now you're ready to find out how so let's get to it.

The first thing you need to do is to highlight the cells to be copied (including the hidden data --don't worry about trying to "skip" it).

Now we need to get to the Go To window. You can do this many different ways - you could use the Edit menu, Go To choice -or- Ctrl + G -or- Alt, E then G -or- F5. Pick one, any one, just so long as you're looking at this window.

Now click the Special button.

In the Go To Special window select the Visible cells only option.

Click OK.

You should be back in your worksheet with the data still highlighted.

Be sure not to click on any cells—you don't want to remove the highlighting as that will also remove the settings you just accomplished.

At this point you're ready for the normal copy and paste—the big difference is that you'll only paste visible data.

Bye-bye hidden data. (Happy dance again.)

~ April

P.S. For readers who need information on hiding (and unhiding) data check out our archives located at http://www.worldstart.com/archives/. Look for the July 16, 2002; the July 23, 2002 and the March 25, 2003 issues.