Key for Formula Bar

S

Stefan Ram

Microsoft says: »Move the insertion point into the Formula
Bar when editing in a cell is turned off. F2«

http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-HP005203781.aspx

Ok, but I have editing-in-a-cell turned /on/. Still, I want
to move the insertation point into the Formula Bar this
time, because I have some value that I can only edit there
(for unknown reasons). Since F2 does not work for this - is
there some other keyboard shortcut I could use?

(I prefer to use the keyboard only. Otherwise I could do
this using the mouse.)

(Then, I observe that Microsoft once started to call the
cursor »caret«, because they wanted to call the mouse
pointer »cursor« - and now they change wording again and
use »insertation point«?

And then they write:

»shortcut menu: A menu that shows a list of commands
relevant to a particular item.«

Wasn't this a »context menu« once? Do they need to change
terminology every decade or is this a
Office-workgroup-vs-Windows-workgroup thing?)
 
S

Stefan Ram

I have some value that I can only edit there
(for unknown reasons)

Possibly, I erred here, because right now it seems
that I also cannot edit this value there.

I have set the short date format of my system to
»yyyy-MM-dd HH:mm:ss«. When editing a cell, Excel
now shows me a time intervall of one hour as

1900-01-00 01:00:00

, but it does not seem to accept this same
text as a date when it is used for input - e.g.,
just pressing return to make Excel read its own
display of the cell value will change the value
type from date to string.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top