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:
- Put the focus on the cell (click, use arrow keys, etc)
- Press space
- Press
Command–ZorControl–Zto 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:
- Put the focus on the cell (click, use arrow keys, etc)
- Press
Control–UorF2to edit the cell (the cursor is now at the end) - Press
Shift–Alt–HomeorShift–Control–Home(to select all text)
note:Homecan also beFn–Left.
Other selections you can make while the cell is in edit mode:
- Press
Shift–Alt–EndorShift–Control–End(to select to the end of the cell)
note:Endcan also beFn–Right. - Press
Shift–Alt–RightorShift–Control–Right(to select one word to the right) - Press
Shift–Alt–LeftorShift–Control–Left(to select one word to the left) - Press
Shift–Alt–DownorShift–Control–Down(to select to the same position on the line below) - Press
Shift–Alt–UporShift–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⌥–Altwhich is the same asOption⌘–CommandFn–Function
–jeroen
The Wiert Corner - irregular stream of stuff 
Leave a comment