While editing an excel cell with large text, cursor moves but text does not, making it difficult to navigate through the text. How do I fix it?

Question

While editing an excel cell with large text, cursor moves but text does not, making it difficult to navigate through the text. Have tried unfreezing panes but I am unable to navigate through the text in cells. How to fix this?

Answer 1

Test data

Answer 2

I agree with the methodology its just that i was able to do the said navigation through large data in single cell 15 days back. Now I cant do it, did something change?

Answer 3

Excel is not good at dealing with large text. If it is possible, copy text to notepad or word to dealing with it and copy back to excel after that.

Other workaround is to expand the column width and zoom in the sheet size.

Here is the icon to upload image.

Could you share us a test file with some dummy data to reproduce your issue.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

Answer 4

Not able to upload the image here, but basically it will be lot of text without cursor in it as cursor moves but the text do not making it difficult to read text that are above or below text in screen.

Answer 5

Could you share us a screenshot (Without sensitive information) of your issue?

Based on your screenshot, then we may give you suggestions on it.