+ Reply to Thread
Results 1 to 5 of 5

Selecting/editing text without the mouse

Hybrid View

  1. #1
    Registered User
    Join Date
    08-07-2005
    Location
    Ann Arbor, MI
    Posts
    7

    Selecting/editing text without the mouse

    Hi,

    For me, it's much easier to use the arrow keys, compared to the mouse, to move up/down and left/right on an Excel spreadsheet.

    When I navigate to a box that already has text in it, is there any way to edit that text (without using the mouse to click on the box)? For example, if I navigate to a box with the arrow keys and start typing, it deletes the contents of the box and starts over. I want to know if there is some key I can press when I have navigated to a box that is equivalent to clicking on the box with the mouse, which then allows you to edit the box.

    Thanks for your help,

    Jason
    Jason Q

  2. #2
    Ian
    Guest

    Re: Selecting/editing text without the mouse

    F2 enters the cell for editing, putting the insertion point at the end to
    the current data.

    --
    Ian
    --
    "JasonQ" <JasonQ.1v5c6a_1126361102.1552@excelforum-nospam.com> wrote in
    message news:JasonQ.1v5c6a_1126361102.1552@excelforum-nospam.com...
    >
    > Hi,
    >
    > For me, it's much easier to use the arrow keys, compared to the mouse,
    > to move up/down and left/right on an Excel spreadsheet.
    >
    > When I navigate to a box that already has text in it, is there any way
    > to edit that text (without using the mouse to click on the box)? For
    > example, if I navigate to a box with the arrow keys and start typing,
    > it deletes the contents of the box and starts over. I want to know if
    > there is some key I can press when I have navigated to a box that is
    > equivalent to clicking on the box with the mouse, which then allows you
    > to edit the box.
    >
    > Thanks for your help,
    >
    > Jason
    >
    >
    > --
    > JasonQ
    >
    >
    > ------------------------------------------------------------------------
    > JasonQ's Profile:
    > http://www.excelforum.com/member.php...o&userid=26014
    > View this thread: http://www.excelforum.com/showthread...hreadid=466502
    >




  3. #3
    Jean Ruch
    Guest

    Re: Selecting/editing text without the mouse


    "JasonQ" <JasonQ.1v5c6a_1126361102.1552@excelforum-nospam.com> schrieb
    im Newsbeitrag
    news:JasonQ.1v5c6a_1126361102.1552@excelforum-nospam.com...
    >
    > Hi,
    >
    > For me, it's much easier to use the arrow keys, compared to the

    mouse,
    > to move up/down and left/right on an Excel spreadsheet.
    >
    > When I navigate to a box that already has text in it, is there any

    way
    > to edit that text (without using the mouse to click on the box)? For
    > example, if I navigate to a box with the arrow keys and start typing,
    > it deletes the contents of the box and starts over. I want to know

    if
    > there is some key I can press when I have navigated to a box that is
    > equivalent to clicking on the box with the mouse, which then allows

    you
    > to edit the box.
    >
    > Thanks for your help,
    >
    > Jason



    Hi,

    See what you can do after pressing key F2

    regards

    Jean


  4. #4
    Earl Kiosterud
    Guest

    Re: Selecting/editing text without the mouse

    Jason,

    Some other techniques you might like to use to avoid using the mouse while
    in a cell are the End and Home keys, selecting text via holding Shift while
    using RightArrow or LeftArrow, Ctrl-C for copy, Ctrl-v for paste. And for
    formulas, Enter or Edit modes (determines whether the arrow keys put cell
    references or just move the cursor) by pressing F2. See
    http://www.smokeylake.com/excel/editing_tips-2.htm for more on that.
    --
    Earl Kiosterud
    www.smokeylake.com

    "JasonQ" <JasonQ.1v5c6a_1126361102.1552@excelforum-nospam.com> wrote in
    message news:JasonQ.1v5c6a_1126361102.1552@excelforum-nospam.com...
    >
    > Hi,
    >
    > For me, it's much easier to use the arrow keys, compared to the mouse,
    > to move up/down and left/right on an Excel spreadsheet.
    >
    > When I navigate to a box that already has text in it, is there any way
    > to edit that text (without using the mouse to click on the box)? For
    > example, if I navigate to a box with the arrow keys and start typing,
    > it deletes the contents of the box and starts over. I want to know if
    > there is some key I can press when I have navigated to a box that is
    > equivalent to clicking on the box with the mouse, which then allows you
    > to edit the box.
    >
    > Thanks for your help,
    >
    > Jason
    >
    >
    > --
    > JasonQ
    >
    >
    > ------------------------------------------------------------------------
    > JasonQ's Profile:
    > http://www.excelforum.com/member.php...o&userid=26014
    > View this thread: http://www.excelforum.com/showthread...hreadid=466502
    >




  5. #5
    Registered User
    Join Date
    08-07-2005
    Location
    Ann Arbor, MI
    Posts
    7

    Thanks

    Thanks for the quick replies, guys!

    You answered my question perfectly.

    -Jason

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1