Forum Discussion
HELP?!?
Hello, I’m new to Excel so please forgive me if I go on and on...lol I am trying to copy and paste a column of sku numbers from my vendors excel file to mine, but when I highlight the column all the...
Hi Kathleen
Instead of highlighting the cells, you may have accidently left clicked into the bottom right corner of the cell (giving you a black +) and dragged that downwards autofilling the first cells value all the way down to the other cells.
If this is what has happened, you will have two options:
1. If you didn't save the file, then it will go back to the original values for the cells. You can right click onto the column letter (e.g. A), select Copy, and right click onto the destination column letter and paste into your new sheet.
2. If you did save the file, the original values may be lost. If you can retrieve a copy of the file with the original values, then do 1. up above.
If I can completely off on my interpretation of the issue, please feel free to ignore me!
Hope that was helpful!
Cheers
Damien
Instead of highlighting the cells, you may have accidently left clicked into the bottom right corner of the cell (giving you a black +) and dragged that downwards autofilling the first cells value all the way down to the other cells.
If this is what has happened, you will have two options:
1. If you didn't save the file, then it will go back to the original values for the cells. You can right click onto the column letter (e.g. A), select Copy, and right click onto the destination column letter and paste into your new sheet.
2. If you did save the file, the original values may be lost. If you can retrieve a copy of the file with the original values, then do 1. up above.
If I can completely off on my interpretation of the issue, please feel free to ignore me!
Hope that was helpful!
Cheers
Damien