Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Give Me The Value And Just The Value

Monday, November 22nd, 2004 by | Filed Under: MS Excel
 
Loading...


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,

image

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.

image

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

image

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

Leave a Reply


Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: