Copy and Paste in Excel Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1600947%22%20slang%3D%22en-US%22%3ECopy%20and%20Paste%20in%20Excel%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1600947%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20not%20an%20expert%20in%20Excel%2C%20but%20use%20it%20on%20a%20daily%20basis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20suddenly%20encountered%20a%20problem%20whereby%20I%20select%20a%20number%20of%20cells%20to%20copy%20and%20paste%20and%20it%20changes%20all%20the%20selected%20items%20to%20what%20is%20in%20the%20first%20cell.%20I%20must%20have%20inadvertently%20touched%20something%2C%20but%20do%20not%20know%20what.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20could%20someone%20advise%20me%20as%20to%20what%20has%20happened%20and%20how%20I%20rectify%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1600947%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601150%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20Paste%20in%20Excel%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601150%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765516%22%20target%3D%22_blank%22%3E%40Robbyj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20attached%20the%20sample%2Fscreenshot%20of%20data%20before%20copying%20and%20after%20pasting%2C%20it%20will%20help%20us%20to%20understand%20you%20issue%20correctly%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601180%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20Paste%20in%20Excel%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601180%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20all%20sorted%20now%2C%20I%20am%20afraid%20I%20was%20having%20a%20senior%20moment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Again%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am not an expert in Excel, but use it on a daily basis.

 

I have suddenly encountered a problem whereby I select a number of cells to copy and paste and it changes all the selected items to what is in the first cell. I must have inadvertently touched something, but do not know what.

 

Please could someone advise me as to what has happened and how I rectify the problem.

 

Thanks 

2 Replies

Hi @Robbyj 

 

Could you please attached the sample/screenshot of data before copying and after pasting, it will help us to understand you issue correctly

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

Hi @Faraz Shaikh 

 

Thanks for your reply.

 

The problem is all sorted now, I am afraid I was having a senior moment.

 

Thanks Again