Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2000
    Location
    Giessen, Noord-Brabant, Netherlands
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It's a simple thing; when I'm entering data in Excel, I often want to use the left arrow to go back and correct something. However, the left arrow moves me to the previous cell. How can I prevent that happening? I suppose I could write code to catch keypresses etc but there must be an easier way.. or isn't there?

    Many thanks,
    Robin

  2. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by robin_freeman View Post
    It's a simple thing; when I'm entering data in Excel, I often want to use the left arrow to go back and correct something. However, the left arrow moves me to the previous cell. How can I prevent that happening?
    Robin

    F2

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Use the <Backspace> key instead of the left arrow

    The arrows are for moving around the spreadsheet. The arrows will to move within the cell if you are in EDIT mode. You can get into edit mode by pressing <F2> or by dbl-clicking on a cell....

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •