in cell editing not working in all cells after coping data from one spreadsheet to another

Occasional Visitor

I copied a section of an existing spreadsheet into another spreadsheet and in cell editing is not working.

When I double click the cursor is at the end of the information in the cell and will only allow me to 

1 Reply


With your permission, I suggest you 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.

What 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 don't forget that 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



I know I don't know anything (Socrates)