Copy and Paste Special (Formulas) pastes cell value if numeric

  • Thread starter korrin.anderson
  • Start date
K

korrin.anderson

Hi - If I have a column of cells, some being formulas, others being
numeric values, if I try to copy and do paste special "formulas" to
another column, it also copies over the values of those numeric cells
in addition to the formulas. Is there any way around this so it just
copies the formulas and does not affect the other cells if there is not
a formula in it?

Thanks!
 
B

Bryan Hessey

If you wanted a copy of only the cells that have a formula and not the
cells that have constants, you could copy and paste the column, then,
with the pasted column selected, Edit, Go To, Special, select
Constants, and press Del to remove them, however this does not preserve
any former values in those cells, for that I think you would need some
VB code.

Does this help?

--
 

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

Copy column, paste special formulas & number formats doesn't work 3
Paste Special Values 2
Copy and paste color 3
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Copy and paste special 2
Copy (Formulas and Formatting ONLY) no values to other rows 1
copy formulas 1
Paste Values in linked Cells Only 4

Top