Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

editing text within a cell before moving to a new cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nicholasburger@gmail.com - 03 Oct 2006 17:08 GMT
Hi -

Does anyone know how to move back and forth through text WITHIN a cell
when first entering text in that cell? (If this is unclear, it's
because I'm not sure quite the best way to explain it). Basically,
imagine I type two words into a cell and realize I've mispelled the
first one. If I hit the left arrow key (ostensibly to move back to the
first word) excel will move me back an entire cell. I then have to (1)
right-arrow over to the original cell, (2) hit F2, and (3) then scroll
back to the misspelled word.

Is there any key modifier I can use to skip directly to (3) without
leaving the cell first? I realize I could use the mouse to move back,
but the idea is to save time/keystrokes if at all possible.

Thanks in advance,
Nick
Gord Dibben - 03 Oct 2006 17:29 GMT
In order to move through the cell using the arrow keys you must be in Edit mode.

When you make a mistake and wish to arrow back a couple of letters, hit F2 then
move with the arrow keys.

OR just hit F2 before you start entering text.

Gord Dibben  MS Excel MVP

>Hi -
>
[quoted text clipped - 13 lines]
>Thanks in advance,
>Nick
nicholasburger@gmail.com - 03 Oct 2006 18:10 GMT
Thanks! I never thought of pressing F2 while entering text, that works
perfectly.

-Nick
Gord Dibben - 04 Oct 2006 00:28 GMT
Somrtimes the most obvious is hidden because we try to look for the more
complex.

Thanks for the feedback.

Gord

>Thanks! I never thought of pressing F2 while entering text, that works
>perfectly.
>
>-Nick

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.