Pasting cell values doesn't remove the formula

  • Thread starter Thread starter HT
  • Start date Start date
H

HT

WindowsXP
Excel2003

I select all, copy, go to a new sheet, edit, paste special, values..its
pastes different numbers and not the number that I previously had on the
sheet.
 
If you select the cell in the original range that looks different after you
paste it, what do you see in that cell?

What do you see in the formula bar for that cell?

Any chance you're copying a range that has hidden rows/columns? Or even pasting
to a range that has hidden rows/columns?
 
Instead of selecting all, try only selecting the range of cells that you
want to copy.
 
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

Count the columns from one sheet and paste it in another sheet 0
Copy and paste the cell boarder only not the content 3
Macro that copies values from column A (from formula) to B (paste value) 1
Record the contents of a cell to be pasted into a "Save As" dialogbox using a macro 2
How can I paste WITHOUT cell references changing (and without usingabsolute cell addresses) [EXCEL20 8
Can't Explain N/A in Vlookup 2
copy and paste named cells 2
Copy/Paste 1

Back
Top