problem hilighting or editing within the EXCEL CONTENTS BOX of the FORMULA BAR

[bromberg]

When I first open a spreadsheet and click on a cell of interest, the cell's content appears in the EXCEL CONTENTS BOX of the FORMULA BAR, as I would expect. I can then move my cursor to a place within this 'edit box' and highlight the portion of the cell that I want to make bold, underline, italicize, change color, etc...with no difficulty. However, lately, I can no longer do this (i.e., when I click on a cell and go up to the 'edit box' the cursor can ONLY be placed at the end of the cell's content and I cannot left-click and highlight the cell's contents at all to edit it as I used to be able to. I am, however, able to backspace and hit the spacebar or start typing, but highlighting is not available.
Also, sometimes the cursor is on top of a character and it is not clear if I am about to edit the character before or after it!?!
There is plenty of cpu and ram available so that's not the issue. If I close and reopen the spreadsheet that sometimes corrects my problem, so it does prove that the cell is not corrupt.
Thanks in advance to all who reply.
Dan

[DocAElstein]

Hello bromberg
Welcome to ExcelFox

I have never seen that problem

Just a couple of things I can suggest.
_1) Have you expanded the formula edit box thing. ( There is something to click on, and then you can drag the bottom up and down:


) Possibly that might reveal something in the cell that you wernt expecting.

_2 The only other thing I can suggest is if you can upload a small workbook that is exhibiting the problem ( remove any sensitive data ) , then me or someone could try in our Excel so that we might at least be able to say if the problem is in the Workbook or your Excel. ( I also have some coding that I could use to check if you have got any strange “invisible” characters in your cells: There are often characters in a text that you don’t see, but they might cause strange effects ( https://excelfox.com/forum/showthrea...ts-of-a-string )


Alan

---

P.S If you have not done it before, uploading a file here is not as simple as it should be. Here are some notes on it:
attachments : https://excelfox.com/forum/showthrea...ll=1#post11279
https://excelfox.com/forum/showthrea...ll=1#post15589