Home

Editing text in a cell: Ctrl+A doesn't select all; ctrl+backspace doesn't delete

%3CLINGO-SUB%20id%3D%22lingo-sub-62354%22%20slang%3D%22en-US%22%3EEditing%20text%20in%20a%20cell%3A%20Ctrl%2BA%20doesn't%20select%20all%3B%20ctrl%2Bbackspace%20doesn't%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-62354%22%20slang%3D%22en-US%22%3E%3CP%3EWanting%20to%20see%20if%20any%20other%20users%20have%20noticed%2C%20have%20thoughts%20around%20this%20issue%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20editing%20text%20in%20a%20cell%20on%20Excel%20for%20Windows%3A%3C%2FP%3E%0A%3CP%3E-%20Ctrl%2BA%20does%20nothing%20(expected%3A%20should%20select%20all%20of%20the%20text%20in%20the%20cell)%3C%2FP%3E%0A%3CP%3E-%20Ctrl%2Bbackspace%20does%20nothing%20(expected%3A%20should%20'delete'%20the%20'word'%20before%20the%20cursor)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20definitely%20been%20a%20painful%20one%20for%20me.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-62354%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-64227%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20text%20in%20a%20cell%3A%20Ctrl%2BA%20doesn't%20select%20all%3B%20ctrl%2Bbackspace%20doesn't%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-64227%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReady%20Mode%20(%20Working%20with%20Range%20)%20-%20%26nbsp%3Bif%20you%20want%20to%20select%20all%20the%20cells%20of%20the%20worksheet%20%2C%20then%26nbsp%3BPress%20Ctrl%20%2B%20A%20twice%20or%20simple%20press%20Ctrl%20%2B%20Shift%20%2B%20Space%20twice%3CBR%20%2F%3E%3CBR%20%2F%3ECtrl%20%2B%20A%20selects%20the%20active%20range%20%2C%20if%20your%20cell%20is%20surrounded%20by%20empty%20row%20and%20column%20%2C%20then%20Ctrl%20%2B%20A%20one%20time%20will%20select%20the%20whole%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Edit%20mode%20(%20working%20with%20cell%20content%20)%20Ctrl%20%2B%20A%20will%20select%20%26nbsp%3Bonly%20the%20cell%20content%20%2C%20%26nbsp%3Balso%20if%20you%20are%20typing%20any%20formula%20then%20ctrl%20%2B%20A%20will%20open%20the%20formula%20argument%20box%20if%20clicked%20after%20the%20open%20paranthesis%20%26nbsp%3Bfor%20eg%20%26nbsp%3B%3D%20sum(%20ctrl%20%2B%20a%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-64224%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20text%20in%20a%20cell%3A%20Ctrl%2BA%20doesn't%20select%20all%3B%20ctrl%2Bbackspace%20doesn't%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-64224%22%20slang%3D%22en-US%22%3EBill%2C%20that's%20what%20I%20do%20every%20day%20many%20times%2C%20just%20prefer%20Ctrl%2BEnd%20first.%20Ctrl%2BA%20would%20be%20much%20better.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-64220%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20text%20in%20a%20cell%3A%20Ctrl%2BA%20doesn't%20select%20all%3B%20ctrl%2Bbackspace%20doesn't%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-64220%22%20slang%3D%22en-US%22%3EHit%20crl-home%2C%20hold%20shift%2C%20hit%20ctrl-end.%20Just%20a%20few%20more%20keystrokes%20and%20easy%20enough.%20I%20use%20Ctrl%20to%20deal%20with%20line%20breaks%20in%20the%20edited%20text.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-62383%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20text%20in%20a%20cell%3A%20Ctrl%2BA%20doesn't%20select%20all%3B%20ctrl%2Bbackspace%20doesn't%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-62383%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Matthew%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20these%20shortcuts%20don't%20work%20in%20cell%20editing%20mode.%20Add%20your%20vote...%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F17690647-ctrl-a-in-edit-enter-and-point-mode-to-select-all%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F17690647-ctrl-a-in-edit-enter-and-point-mode-to-select-all%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880684%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20text%20in%20a%20cell%3A%20Ctrl%2BA%20doesn't%20select%20all%3B%20ctrl%2Bbackspace%20doesn't%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880684%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416757%22%20target%3D%22_blank%22%3E%40akash720%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJust%20Shift%2BHome%20is%20enough%2C%20focus%20is%20at%20end%20by%20default%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880641%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20text%20in%20a%20cell%3A%20Ctrl%2BA%20doesn't%20select%20all%3B%20ctrl%2Bbackspace%20doesn't%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880641%22%20slang%3D%22en-US%22%3EHit%20Home%20and%20then%20Shift%2BEnd.%3C%2FLINGO-BODY%3E
Matthew Sheets
Microsoft

Wanting to see if any other users have noticed, have thoughts around this issue:

 

When editing text in a cell on Excel for Windows:

- Ctrl+A does nothing (expected: should select all of the text in the cell)

- Ctrl+backspace does nothing (expected: should 'delete' the 'word' before the cursor)

 

It's definitely been a painful one for me.

 

6 Replies
Hit crl-home, hold shift, hit ctrl-end. Just a few more keystrokes and easy enough. I use Ctrl to deal with line breaks in the edited text.
Bill, that's what I do every day many times, just prefer Ctrl+End first. Ctrl+A would be much better.

 

Ready Mode ( Working with Range ) -  if you want to select all the cells of the worksheet , then Press Ctrl + A twice or simple press Ctrl + Shift + Space twice

Ctrl + A selects the active range , if your cell is surrounded by empty row and column , then Ctrl + A one time will select the whole sheet.

 

In Edit mode ( working with cell content ) Ctrl + A will select  only the cell content ,  also if you are typing any formula then ctrl + A will open the formula argument box if clicked after the open paranthesis  for eg  = sum( ctrl + a

@akash720 

Just Shift+Home is enough, focus is at end by default

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies