Values not formula paste

  • Thread starter Thread starter Kippie
  • Start date Start date
K

Kippie

I copied cells containing values and formulas. When
pasted on a new worksheet, only values are displayed, not
the formulas. What have I turn off??
 
Instead of clicking paste - click paste special on the
edit menu and then 'All'
 
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

Scrabble Value calculation for Welsh words 0
Excel VBA 1
Totalling sequential worksheets 1
Calculate After hours 3
Formulas displayed in cell rather than calculated values? 4
Can't Copy and Paste in Excel 2003 0
formula finds values in apparently blank cells 1
Copying formulas in range and pasting in a selection 3

Back
Top