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
 
Top