Forum Discussion

Kathleen Lemerise's avatar
Kathleen Lemerise
Copper Contributor
Apr 07, 2018

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 cells turn to the same numbers as the top cell in that column...I’m not sure how to fix this!
Please let me know if anyone can advise me on how to fix this problem...
Much Appreciated
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Apr 07, 2018

    Hi Kathleen,

     

    How do you highlight the column? For example, to copy entire column A your click on letter "A" on the top of the column to select it, when click Copy, go to another sheet, select the column you need as above and click Paste. Something like this?

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Apr 09, 2018
    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

Resources