how can i copy datas from a cell which contains formula

  • Thread starter Thread starter japram
  • Start date Start date
J

japram

how can copy data from a cell which contains formula. i need the actual value
of the cell .pls help
 
Just copy like normal but when you go to paste right click and paste special
and then select values.
 
Hi,

Here is one other trick: Suppose the formula is in A1 with B1 empty.
Select cell B1 and press Shfit+Ctrl+"

This copies the value of the cell above without the formula.

Depending on where you want to copy the contents:
Highlight the formula on the Formula Bar and press F9, then Copy. Press Esc
and move to the destination and press Paste. (This is particularly useful
when you want to copy and paste the value to another application such a Word,
or into a formula in Excel.)
 
You must log in or register to reply here.

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

Extending a selection 1
Converting a formula to data 3
Copy data from once worksheet to another using formula 2
Copy formulas down a column containing data 1
To execute a formula upto in a cell 3
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Excel - formula last data cell 2
Reference Formula Help 1

Back
Top