I have a situation where I have 3 cells; the third cell is rather long and goes way outside the screen view.
The second column I am working with and I constantly need to copy parts of text from the 3rd column to paste into the 2nd column, however every time I double click the 3rd column so I can copy/paste Excel jumps so it can try and display the whole column and hence every time after I copy the data I have to navigate back to where I was so I can how paste the data.
FYI I am using Office 2010.
Is there any way to stop this behaviour?