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
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.Screenshot 2019-08-05 at 12.08.56 AM.pngLeft copied, right pastedScreenshot 2019-08-04 at 11.13.58 PM.pngLeft copied, right pasted

3 Replies

@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 the topic fully in graphics. In this tutorial I show you How to copy a range that includes Filtered or Hidden Rows and when pasting you only

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.

@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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies