RE: [PCTECH] Two Excel questions

["Ritsema, Doug B" <Doug.Ritsema@xxxxxxxxx>]

Not sure if this is what you are looking for but...
once the focus is on the cell that you want hit F2 to bring it up to the
formula bar.  Then you can use the arrow keys to edit the cell contents.

-----Original Message-----
From: Dan Bale [mailto:dbale@xxxxxxxxxxxxx]
Sent: Friday, August 27, 2004 9:35 AM
To: pctech@xxxxxxxxxxxx
Subject: [PCTECH] Two Excel questions


Excel 2000 (on W2K)  (BTW, can anyone suggest helpful Excel web sites that
have tutorials and useful forums?)

<Snip>

2) There are two methods that I am aware of to edit a cell.  The first is
when the cursor/focus is in the cell on the sheet.  The second is when the
cursor/focus is up in the Formula Bar.  Since I am not the world's best
typist, and I normally go for speed more than accuracy, I often find that I
need to back up in the cell to make a correction.  The default entry focus
is in the cell on the sheet; when I attempt to use any of the <cursor arrow>
keys to maneuver around in the cell, the cell loses focus and focus changes
to an adjacent cell, and then I have to move my hand from the keyboard to
the mouse, move it to the Formula Bar, and click.  This is a huge
time-waster for me.  Once the focus is in the Formula Bar, I can use the
<cursor arrow> keys to maneuver around the cell's contents.

I understand that the design of the <cursor arrow> keys is a huge part of
how one maneuvers around in Excel, but I am such a keyboardist that I would
rather be able to limit the <cursor arrow> keys to maneuver within a cell
and have only the mouse and tab keys to change focus to different cells.

There's gotta be a way.

--
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.