Home

My pasted content isn't the same as my copied content

%3CLINGO-SUB%20id%3D%22lingo-sub-787391%22%20slang%3D%22en-US%22%3EMy%20pasted%20content%20isn't%20the%20same%20as%20my%20copied%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787391%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20copy%20an%20entire%20column%20(control-spacebar)%20and%20paste%20it%20into%20the%20next%20column%2C%20the%20information%20is%20wrong%2C%20and%20I%20only%20get%20a%20handful%20of%20values.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20596px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125538iB96305A79A163AB5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot%202019-08-05%20at%2012.08.56%20AM.png%22%20title%3D%22Screenshot%202019-08-05%20at%2012.08.56%20AM.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ELeft%20copied%2C%20right%20pasted%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20262px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125539iFF58C13B9EA450E9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot%202019-08-04%20at%2011.13.58%20PM.png%22%20title%3D%22Screenshot%202019-08-04%20at%2011.13.58%20PM.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ELeft%20copied%2C%20right%20pasted%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-787391%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787398%22%20slang%3D%22en-US%22%3ERe%3A%20My%20pasted%20content%20isn't%20the%20same%20as%20my%20copied%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787398%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387018%22%20target%3D%22_blank%22%3E%40missmasturah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EIf%20you%20copy%20Cells%20having%20Formulas%20using%20cell%20references%20then%20these%20formulas%20when%20pasted%20change%20to%20reflect%20a%20new%20position.%3C%2FP%3E%3CP%3EIf%20you%20just%20want%20the%20same%20values%20then%20use%20paste%20special%20which%20returns%20constants%20and%20text%20(CTRL%20%2BC%20%26gt%3B%26gt%3B%3CSTRONG%3EALT%2C%20E%2C%20S%2C%20V%26nbsp%3B%3C%2FSTRONG%3Eenter%3C%2FP%3E%3CP%3EYou%20can%20also%20copy%20to%20the%20right%20by%20using%20the%20shortcut%20%3CSTRONG%3ECTRL%20%2B%20R%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20from%20your%20selection%2C%20I%20can%20tell%20that%20you%20have%20Hidden%20or%20Filtered%20Rows%2C%20which%20means%20you%20need%20to%20%3CSTRONG%3ECopy%20and%20Paste%20ONLY%20Visible%20Rows%3C%2FSTRONG%3E.%20If%20this%20is%20the%20case%20then%20here%20is%20my%202%20minutes%20tutorial%20on%20how%20to%20do%20that%2C%20watch%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DNizvmjfclZ0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DNizvmjfclZ0%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787402%22%20slang%3D%22en-US%22%3ERe%3A%20My%20pasted%20content%20isn't%20the%20same%20as%20my%20copied%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787402%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Nabil%2C%20thanks%20for%20responding.%3C%2FP%3E%3CP%3EFor%20the%20numbers%20what%20I%20copied%20an%20entire%20column%20and%20special%20pasting%20it%20as%20values%2C%20without%20formula%20(which%20I%20think%20is%20what%20you%20suggested)%3CBR%20%2F%3EHowever%20for%20the%20text%2C%20I%20did%20a%20regular%20copy%20and%20pasting%20since%20there%20were%20no%20formula%2C%20but%20as%20you%20can%20see%2C%20the%20copy%20and%20the%20pasted%20is%20a%20mismatch%20of%20value.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787406%22%20slang%3D%22en-US%22%3ERe%3A%20My%20pasted%20content%20isn't%20the%20same%20as%20my%20copied%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787406%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387018%22%20target%3D%22_blank%22%3E%40missmasturah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20again%3C%2FP%3E%3CP%3EI%20am%20almost%20sure%20your%20problem%20is%20to%20Copy%20and%20paste%20Visible%20cells%20only.%3C%2FP%3E%3CP%3EI%20definitely%20encourage%20you%20to%20spend%202%20minutes%20on%20the%20tutorial%20sent%20in%20my%20previous%20reply%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ENabil%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
missmasturah
New Contributor

When I copy an entire column (control-spacebar) and paste it into the next column, the information is wrong, and I only get a handful of values.Left copied, right pastedLeft copied, right pastedLeft copied, right pastedLeft copied, right pasted

3 Replies
Highlighted

@missmasturah 

Hi

If you copy Cells having Formulas using cell references then these formulas when pasted change to reflect a new position.

If you just want the same values then use paste special which returns constants and text (CTRL +C >>ALT, E, S, V  enter

You can also copy to the right by using the shortcut CTRL + R

 

However from your selection, I can tell that you have Hidden or Filtered Rows, which means you need to Copy and Paste ONLY Visible Rows. If this is the case then here is my 2 minutes tutorial on how to do that, watch it:

https://www.youtube.com/watch?v=NizvmjfclZ0

 

Hope that helps

Nabil Mourad

This is a Bite-Size Excel Tutorial Series (less than 3 minutes) targeting anyone on the globe using Excel since I broke the barrier of language and I explain...
Highlighted

Hi Nabil, thanks for responding.

For the numbers what I copied an entire column and special pasting it as values, without formula (which I think is what you suggested)
However for the text, I did a regular copy and pasting since there were no formula, but as you can see, the copy and the pasted is a mismatch of value.

Highlighted

@missmasturah 

Hello again

I am almost sure your problem is to Copy and paste Visible cells only.

I definitely encourage you to spend 2 minutes on the tutorial sent in my previous reply

Thanks

Nabil

Related Conversations