Announcements

Last Chance - Almost Gone!

The Microsoft PictureIt Publishing 2002 Platinum Edition went like crazy on Friday! Thanks to all who ordered. Although we sold through most of our stock, we still have a few left. So, if you missed out, here's one more chance.

Again, these are on sale for only $24.97 - with FREE US SHIPPING! This retails for $59.95, so you save nearly 60%!!

You can create greeting cards, e-mail cards, calendars, newsletters, web pages, invitations, announcements, labels, animated greetings, business cards, flyers, signs, stationary, T-shirts, stickers, web photo albums, party sets, recipe cards, awards, certificates, banners, and tons more. (whew) All done in a very easy step by step manner!

It also includes over 15,000 different templates, 200 font styles, 3500 sentiments, 1500+ animated greetings, 2800 sounds, and over 5000 quotes!

You can use your own photos (and edit them with a host of powerful tools) or choose from over 250,000 different clipart images (designed by over 200 artists)! You don't need to worry about finding that perfect image anymore!

One of the coolest features this program has is helpful little movies that show you how to do basic operations. Regular help files are good, but learning by watching is best!

If you missed out on Friday, now's the time to grab one for yourself! This is an awesome program and we're almost out! Get to the link below right now:

http://www.worldstart.com/store/picture-it-platinum.htm

Don't hate yourself for missing out! Skip the rest of the newsletter for now and head to the site :-)

MS Office 101

Copy / Paste Keyboard Shortcuts

Since today's tip revolves around copy and paste I thought I'd take this opportunity to quickly review the keyboard shortcuts for copy / paste and deletion functions.

I've also found a keyboard trick in MS Word for moving text around in a document.

So, let's get to it…

• Ctrl + C = copies the highlighted text to the clipboard**
• Ctrl + V = pastes the clipboard contents into the file
• Ctrl + X = cuts the highlighted text from the document**
• Ctrl + Backspace = deletes one word to the left of the cursor
• Ctrl + Delete = deletes one word to the right of the cursor

And… here's the key combination for moving text from one location to another in MS Word.

First highlight the text to be moved.**

Then press F2.

Now move to the location where you'd like the text to be inserted.

Finally, press the Enter key.

This last one works well. It's quick and easy. For those readers who love the keyboard it's not a bad way to stay away from the mouse and it's a few less keys than a cut and paste.

** Highlighting text using the keyboard was covered in the March 28, 2002 issue. To view this issue online, go to our archives located at http://www.worldstart.com/archives/ms-office-tips/2002/03-28-2002.htm

Office Tip of the Day

Give Me The Value And Just The Value

Have you ever found yourself working in MS Excel and wishing you could paste the value of a formula instead of the formula?

Or maybe you found yourself scrolling back and forth in a worksheet or flipping between different worksheets trying to type the value in by hand - desperately hoping you get it accurate.

You know what I'm referring to, the times when you're trying to copy a value to another location and you only need the value - not the formula it came from.

When you finished the copy / paste what you probably had was a zero or some other incorrect number because the formula was pasted with relative cell references. (That is, if the formula is to add the two cells to the immediate left then the pasted formula is adding the cells to the immediate left of the new location. Therefore, the value has changed because the two cells to the left have changed.)

Wish you had a way to paste the value -just the value?

Yes?

Good - then you're in the right place.

What you need to put an end to your nightmare is Paste Special.

(Be careful here - you need Paste Special, not a simple Paste.)

So, how do you get the infamous Paste Special to work for you?

Believe it or not, it's only a couple extra clicks beyond the usual copy / paste that you perform every day.

Well - enough of that - let's get started.

The first thing you need to do is to highlight the cell or cells you need to copy.

Next you'll need to copy just like normal. Either with the copy button,

the Edit menu, Copy choice or with the key combination Ctrl + C.

The third step is to select the cell where you want to paste the values.

Now you're ready to paste - but instead of the usual paste you'll need to go the Edit menu, Paste Special choice.

The Paste Special window will pop open allowing you to make your pasting choices.

You're looking for the Values choice.

Once you've made the selection click OK.

In the selected cell you should have the value - not the formula - from the cell originally copied.

And there you have it - the value and only the value. If only it could be so easy to get everything we ask for in life.

~ April