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 / Worksheet Functions / June 2006

Tip: Looking for answers? Try searching our database.

how to select cells with keyboard if the arrows don't let you go out of the formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
reader.life@gmail.com - 15 Jun 2006 19:03 GMT
Hi,

I've got a problem using keyboard to select cells when editing some "
sticky" formula. By "sticky", I mean when the arrows don't move you out
of the cell you are editing.

I found this problem does not exist when starting a new formula, where
you can use arrow keys to select other cells. It is a problem for
editing existing formula.

For example, when you return to re-edit an existing formula like the
MIN, once you insert the cursor there, the arrow keys only moves within
the cell rather than allowing you to select other cells needed to
complete the formula.
Bernard Liengme - 15 Jun 2006 19:17 GMT
Press F2 when editing formula - it takes practice to get it right
Why not just pull the 'range finder' borders?
best wishes
Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address

> Hi,
>
[quoted text clipped - 10 lines]
> the cell rather than allowing you to select other cells needed to
> complete the formula.
Gary L Brown - 15 Jun 2006 19:23 GMT
The 'F2' key toggles you between 'sticky' edit and 'moving' edit.
HTH,
Signature

Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

> Hi,
>
[quoted text clipped - 10 lines]
> the cell rather than allowing you to select other cells needed to
> complete the formula.
 
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.