The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Email Subscription

    Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 717 other subscribers

ms office – Keyboard shortcut to select all text in a cell in Excel – Ask Different

Posted by jpluimers on 2019/06/10

Via [WayBack] ms office – Keyboard shortcut to select all text in a cell in Excel – Ask Different a few keyboard tips.

Lets start with the shortest one:

  1. Put the focus on the cell (click, use arrow keys, etc)
  2. Press space
  3. Press Command–Z or Control–Z to undo the change

This probably is unintended, but works great: all text is now selected, so you can copy/cut with Command-C/Command–X.

Now the “official” way:

  1. Put the focus on the cell (click, use arrow keys, etc)
  2. Press Control–U or F2 to edit the cell (the cursor is now at the end)
  3. Press Shift–Alt–Home or Shift–Control–Home (to select all text)
    note: Home can also be Fn–Left.

Other selections you can make while the cell is in edit mode:

  • Press Shift–Alt–End or Shift–Control–End (to select to the end of the cell)
    note: End can also be Fn–Right.
  • Press Shift–Alt–Right or Shift–Control–Right (to select one word to the right)
  • Press Shift–Alt–Left or Shift–Control–Left (to select one word to the left)
  • Press Shift–Alt–Down or Shift–Control–Down (to select to the same position on the line below)
  • Press Shift–Alt–Up or Shift–Control–Up (to select to the same position on the line up)

Keyboard symbols (more at [WayBack] Command, Option, & Shift Symbols in Unicode):

  • ⇧ – Shift
  • ^ – Control
  • ⌥ – Alt which is the same as Option
  • ⌘ – Command
  • Fn – Function

–jeroen

Leave a Comment