Cells turn red in a table

%3CLINGO-SUB%20id%3D%22lingo-sub-3079534%22%20slang%3D%22en-US%22%3ECells%20turn%20red%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3079534%22%20slang%3D%22en-US%22%3E%3CP%3EWhenever%20I%20copy%20and%20paste%20a%20cell%20to%20the%20cell%20just%20below%20it%2C%20both%20cells%20will%20turn%20red.%20It%20will%20only%20become%20white%20again%20if%20I%20type%20something%20else%20in%20either%20one%20of%20the%20cells.%20Any%20idea%20why%3F%20It%20did%20not%20happen%20before%20when%20I%20used%20another%20laptop.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3079534%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3088544%22%20slang%3D%22en-US%22%3ERe%3A%20Cells%20turn%20red%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3088544%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1289943%22%20target%3D%22_blank%22%3E%40rejoicingalways%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmove-or-copy-cells-and-cell-contents-803d65eb-6a3e-4534-8c6f-ff12d1c4139e%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMove%20or%20copy%20cells%20and%20cell%20contents%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmove-or-copy-cells-rows-and-columns-3ebbcafd-8566-42d8-8023-a2ec62746cfc%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMove%20or%20copy%20cells%2C%20rows%2C%20and%20columns%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20links%20not%20helps%E2%80%A6%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20I%20recommend%20to%20provide%20more%20information.%3C%2FP%3E%3CP%3EYou'll%20get%20a%20quicker%20and%20more%20accurate%20answer%2C%20and%20those%20who%20want%20to%20help%20don't%20have%20to%20invest%20time%20guessing%20the%20problem.%3C%2FP%3E%3CP%3EI%20recommend%3A%20Always%20inform%20about%20your%20Excel%20version%2C%20operating%20system%2C%20storage%20medium%2Fhard%20drive%2C%20OneDrive%2C%20Sharepoint%2C%20etc.).%3C%2FP%3E%3CP%3EIf%20possible%2C%20add%20a%20file%20(without%20sensitive%20data)%20and%20use%20this%20file%20to%20describe%20your%20project%20step%20by%20step%2C%20or%20add%20photos%20with%20the%20appropriate%20description.%3C%2FP%3E%3CP%3EDon't%20forget%20that%20not%20every%20Excel%20user%20has%20a%20clue%20about%20every%20job%20and%20what%20you%20see%20he%20can't%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20link%20you%20will%20find%20some%20more%20information%20about%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Whenever I copy and paste a cell to the cell just below it, both cells will turn red. It will only become white again if I type something else in either one of the cells. Any idea why? It did not happen before when I used another laptop.

1 Reply

@rejoicingalways 

Move or copy cells and cell contents

Move or copy cells, rows, and columns

 

If the links not helps…

With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

 

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)