Can't select all text in Excel cell (neither with CTRL+A)

How to select all text when I am inside cell ?

neither SELECT ALL appears, nor CTRL+A does anything. (p.s. I am interested only when I am inside cell "EDIT MODE", not clicking the cell itself and copying).

2 Answers

If you can get your cursor to the end of the text in the cell, try pressing Ctrl + Shift + Home.

Alternatively, if you can get your cursor to the start of the text in the cell, try pressing Ctrl + Shift + End.

2

You can use AHK to create custom shortcut. This script will only remap CTRL+A if Excel is the active window.

SetTitleMatchMode RegEx
#If WinActive("ahk_exe EXCEL.EXE")
^a::
Send {Home}
Send ^+{End}
return
#IfWinActive

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy