Page 1 of 1

[Solved] Problem I Have

Posted: Wed Jan 16, 2019 8:12 pm
by fjwag3
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

Re: Problem I Have

Posted: Wed Jan 16, 2019 8:21 pm
by FJCC
Select the menu Tools -> AutoCorrect Options. On the Options tab, remove the selection from Correct Two Initial Capitals.

Re: Problem I Have

Posted: Wed Jan 16, 2019 8:25 pm
by 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. :shock:

Re: Problem I Have

Posted: Wed Jan 16, 2019 9:11 pm
by 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.

Re: Problem I Have

Posted: Wed Jan 16, 2019 9:28 pm
by fjwag3
It happens randomly, no big deal. Thanks for your offer.

Re: Problem I Have

Posted: Thu Jan 17, 2019 2:45 pm
by 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.

Re: Problem I Have

Posted: Thu Jan 17, 2019 9:00 pm
by 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.

Re: Problem I Have

Posted: Fri Jan 18, 2019 10:44 am
by 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
Villeroy wrote: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
keme wrote: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.

Re: Problem I Have

Posted: Thu Jan 31, 2019 7:07 am
by fjwag3
OK!.......Thanks All.