Dear Microsoft Excel Tips subscriber,



Here's another useful Microsoft Excel tip from Element K

Journals, your number one source for software tips and

techniques.



PLEASE VISIT OUR SPONSOR

***********************************************

An Ideal Resource For All Digital Camera Users!

***********************************************

Learn how to shoot like a pro, add special effects to images,

and more with our Digital Photography Skill-Building Series. Six

20-page, full-color guides - only $9.95 each - give essential

tips and techniques for digital camera users. Get all 6 for

$55.95, plus free shipping*! Order now at

http://www.elementkjournals.com/buy/showPromo.asp?coupon=115810

*Free shipping applies to U.S. residents only.



********** THE TIP **********



Accomplish two tasks at once with the Paste Special command

(Microsoft Excel 97/2000/2002/v. X/2003)



The Paste Special command offers several options for effectively

controlling what and how you paste your Excel data. One of those

options includes performing calculations with the data you're

ready to paste and the data in the cells to which you're pasting.

For example, let's say you'd like to copy the Quarter 1 Sales to

another cell in your worksheet and then add the copied value to

the figure in the cell where you're pasting. You can do it all in

one step. Select the cell and press [Ctrl]C ([command]C in v. X)

to copy it. Then, select the cell containing the value with which

you'd like to sum the copied data. Choose Edit | Paste Special

from the menu bar to access the Paste Special dialog box. Then,

select the Add option button in the Operation panel and click OK.

The new cell's original value is overwritten with the sum of the

two values. So, as long as you're aware that you can't preserve

the value in the cell or range to which you're pasting, you can

perform simple operations while you move data. In addition to

summing, you can also multiply, subtract, and divide.



Click here to email this tip to a friend, and you'll both get an online

coupon to save 20% off all items purchased at www.elementkjournals.com.



PLEASE VISIT OUR SPONSOR

****************************************************************

NEW! Computer-Based Training CDs for Microsoft Office 2003 users

****************************************************************

Beginner or expert, now you can teach yourself how to use the

applications within the Microsoft Office 2003 Suite with Element

K Journals' NEW Computer-Based Training CDs. Choose from CDs

available for each of these Microsoft Office 2003 applications:

- Access - PowerPoint

- Excel - Word

- Outlook



Order the CDs of your choice today and save more than 17%!

For more information, or to order now, go to:

http://www.elementkjournals.com/buy/showPromo.asp?coupon=115811



********** SUBMIT A TIP! **********



Do you have a shortcut or technique that's tip worthy? If so,

send it to ime_editor@elementk.com . If we use your submission,

we'll include your name and email or Web address, along with

the tip.



********** SERVICES **********



Want to sign up for your own tips? If this tip was forwarded

to you by a friend and you would like to receive your own

FREE tips, sign up at

http://www.elementkjournals.com/tips.asp



This weekly tip is delivered to you as a free service from

Element K Journals,

http://www.elementkjournals.com/tips.asp



***********************************************************

Copyright (c) 2005 Element K Content LLC ("Element K"). All

rights reserved except the right to make private,

noncommercial use hereof. The content in this email (the

"Tips") is the property of Element K or its affiliates and

is protected by copyright law in the U.S. and elsewhere.

This means that the right to copy and publish the Tips is

reserved, even though the Tips are made available by this

service for free; the Tips may not be copied in whole or in

part or further distributed in any form or medium without the

express written permission of Element K. Questions or requests

for permission to copy or republish any content may be

directed to contentreuse@elementk.com.



All product names or services identified throughout this

email are trademarks or registered trademarks of their

respective companies. QuickSkill and QuickSkill 3 CBT are

trademarks of Element K LLC.



********** CHANGE YOUR EMAIL ADDRESS **********

Do you want your tips sent to a new email address?

Simply submit an email to customer relations at

http://www.elementkjournals.com/custserv/tipsemail.asp



**************************************************************



-----------------------------------------------------------

To discontinue your subscription to this tip, please click the link below:

Unsubscribe me from this tip only



To discontinue all communication from Element K Journals

via email, please click the link below:

Unsubscribe me



If you experience any problems with the links above, or would like to

speak with one of our customer relations representatives, please call our

customer relations team at 1-800-223-8720. (Canada: (877) 203-5248,

Outside of the U.S. and Canada: (585) 240-7301).



Element K Journals

500 Canal View Blvd.

Rochester, New York 14623



------------------------------------------------------------

Email sent by Element K using software from M4Internet.

------------------------------------------------------------