how can i copy datas from a cell which contains formula

J

japram

how can copy data from a cell which contains formula. i need the actual value
of the cell .pls help
 
C

Chad Portman

Just copy like normal but when you go to paste right click and paste special
and then select values.
 
S

Shane Devenshire

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.)
 

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
i want to know formulas in MS-Excel2003 3
Macro - specific range 3
Function to determine if a cell contains a formula 5
Can a text box use a formula or cell reference 3
Reference Formula Help 1

Top