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...
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.
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
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
