How to COPY from cells to cells w/o affecting respective formulae underneath ?

E

EduardoDon

Would highly be appreciated if can be told on:

How to copy data from
cells ( formulated with "a") to
cells ( formulated with "b")

without affecting respective formulae underneath after being pasted ?


Thanks in advance.

EduardoD
 
L

Leanne

Hi,

When pasting, right click on the target cell and
select "Paste Special", "values", "ok". This will
populate the value of the cell without the formula.
 

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

Applying Formulae to a worksheet which are hidden 11
Copy and paste slide from one presentation to another presentation gives an error 2
Copy data automatically from sheet1 to sheet2 0
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
how to compare formula's values? 4
How do I copy data (word) into respective cells when the data bei. 1
How to create a graph from the data of an existing table in the PowerPoint? 1
How to get rid of hyperlinks? 8

Top