[Solved] Problem I Have

[Hagar Delest]

I need two Upper Case letters no space abbreviation in one cell, just whenever I need it, just where ever it goes. It is auto changed and makes the 2nd letter lowercase.
Must be a setting I'm missing.

Thanks in advance

FJW

[FJCC]

Select the menu Tools -> AutoCorrect Options. On the Options tab, remove the selection from Correct Two Initial Capitals.

[fjwag3]

Much appreciated.

Here is another one.....sometimes I can't move to the next cell w my arrow key. Certain group of cells always seem to work, others are iffy.

[FJCC]

Can you upload a document showing the problem with moving into some cells? To do that, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.

[fjwag3]

It happens randomly, no big deal. Thanks for your offer.

[keme]

In "edit mode" the arrow keys only navigates insertion point (text cursor) inside cell content. It won't move the cell selection until you exit the edit mode (by pressing tab, enter or F2, or clicking elsewhere in the grid).
Edit mode can be invoked by the F2 function key (toggle) and by clicking in cell content in the formula bar.

[Villeroy]

While in edit mode F2 toggles between text cursor movement and reference pointer mode.
Hit F2 to edit the cell. Now you are in either mode.
Hit F2 another time and you are in the other mode.

[keme]

Quite so, Villeroy. Thanks!

Cell entry in a spreadsheet is a bit more complex than what immediately comes to mind. Cell content can be "active" (formula) or "passive" (data), and editing behaves differently for the two classes of content.

To summarize:

Formula entry

While in edit mode F2 toggles between text cursor movement and reference pointer mode.
Hit F2 to edit the cell. Now you are in either mode.
Hit F2 another time and you are in the other mode.

Formula entries are invoked by starting the cell entry with equals sign, plus or minus.

Data entry

In "edit mode" the arrow keys only navigates insertion point (text cursor) inside cell content. It won't move the cell selection until you exit the edit mode (by pressing tab, enter or F2, or clicking elsewhere in the grid).
Edit mode can be invoked by the F2 function key (toggle) and by clicking in cell content in the formula bar.

Data entry (plain number/text) is invoked by starting with any character other than those mentioned above. Data entry can also be forced by preformatting the cell to interpret everything as text.

[fjwag3]

OK!.......Thanks All.