Copying one column to another column, but retaining values

[zutalors212]

Suppose that I have many rows of data. Row A is a function of Row B.
Let's say that the cells of cell A12=B12*2+4.

Now suppose that I want to copy the column A (control C - not Control
X), and paste it to Column Z. I don't want the pasted values to equal
AA*2+4.

How do I copy/paste cells with formulas without losing my original
values?

 

[Ian G]

The way I know is a bit involved, but works well.

Highlight the cells in column A that you want to move to column z.
Don't highlight the whole column.
Copy
Move the cursor to an empty area below these cells in column A
Paste
With the same selection, Cut
Move the cursor to column Z on the same starting row row
Paste
With the same selection, Copy
Move the cursor to the row you want the formulae to be in and Paste
Delete the cells from the bottom of column Z

Ian G

 

[via135]

hi!

Edit > Copy > Paste special > select "values" > click "ok"

your values alone will be there!

-via135

 

[Dave Peterson]

Why not just point the formula in column Z to column A?
=A12

Then you don't have to fix the formulas in two spots...

But if you want values in column Z, you can
select column A
edit|copy
select Z1
Edit|paste special|Values

If you want Z to contain the exact formula, you can:
select column A
edit|replace
what: = (equal sign)
with: $$$$$
replace all
edit|copy
Select Z1 and edit|paste

Now select column A and column Z
and reverse the change
edit|replace
what: $$$$$
with: =
replace all