Paste By Values Has a New Look, Try this!

Can any body tell me how many ways you can copy paste the formulas to values using Excel? Post your answers in the comments section below.

I know 3 methods. Once you copy the data:

1. Use ALT + E + S + V

2. Use Paste Special Window to paste by values

and the third one is some thing new to all. For that matter, it is even new to me till last month. Do you want to know what it is?

Am I creating curiosity to learn this? :)

...

Here it is:

1. Select the range of cells which has to convert formulas to values

2. Use mouse to select the right corner by pressing the right mouse click and move towards the other column and keep it back to the same or target column

3. Leave the mouse right click which shows few options

4. Choose "Copy here as Values Only" to paste the formulas or formats by values.

That's it. Magic works!!!

Don't you think this is a cool tip. Enjoy Excelling!!!

If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog. If you want to support me REGISTERhere for free. You will be receiving the latest updates from the blog directly into your registered email id. We strictly follow data security.