Copy and Paste issue?
I am just trying to do a simple copy and paste of a row. I highlight a row. select copy. Highlight a row where I would like the new row to be placed above. when I select paste, it place a new row with different information in the cells?
anyone else have copy and paste issues?
Answers
-
Does the row you are copying contain formula? Is your paste pasting in the formula and therefore displaying something different because of the new position of the row?
-
It does contain formulas in the cells tied to anther sheet. I trying to copy a "clean" row and it pastes with information. I'm not sure where it would even pull that from since it doesn't match up to anything on the other sheet.
-
I found my answer. As usual, user error. my other sheet had a blank cell it saw and was pulling info from it.
sorry for the false alarm!
