Copying data created by a formula

F

Felipe I

Select the data, click copy, move to the new column
location and use Paste Special>Values. You can access
paste special by right-clicking a cell or in the edit menu
 
J

Jon Peltier

You can also select the range, drag it with the right mouse button, and
choose Copy Here as Values from the popup menu when you release the mouse.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
Embed the same Excel multiple times 0
Copy addition formula of non-consecutive horizontal cells 2
Linking data in MS Word into Excel 5
Visio shape text disappears upon copy paste 1
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Cell data entering slow! 0
Creating a Chart on form from selected data in query. 0

Top