The quickest way I've found is the following: 1) tab/select the cell, 2) hit backspace to delete the contents of the cell 3) type Cntrl+Z to undo delete When the undo function puts the text back into the cell, all text within that cell is automatically highlighted. Then you can just type Cntrl+C to copy text only.
How To Remove Highlighting In Word
VoiceOver provides many ways to read text. You can read text a word, line, sentence, or paragraph at a time. You can hear words and characters spelled phonetically. As you read, you can pause and resume speaking by pressing the Control key. If you’re using VoiceOver gestures, tap two fingers on the trackpad. When I click on any text, some strange phenomenon occurs. An alien of some sorts keeps highlighting the text, and the text simply refuses to become unhighlighted. The whole page is inundated with highlighted text. To highlight multiple chunks of text, double-click the Text Highlight button. The mouse pointer stays in highlighting mode until you click the Text Highlight button again or press the Esc key. To highlight a block of text, mark the block and then click the Highlight button that appears on the mini toolbar.
The copied text can also be copied into other word processing programs, text editing programs, or other programs that accept text or even into an email. You don’t have to paste the copied text into a Word file.
![Text Text](https://exceljet.net/sites/default/files/images/lesson/screens/How%20to%20highlight%20text%20values%20with%20conditional%20formatting_SS.png)
I found that I needed to highlight all text in a cell in order to be able to paste it back inside another excel sheet whose cells already had other text that I had to leave intact. Hope this helps! The great thing about copying the contents of the cell rather than the cell itself is to grab the contents without any formatting (plain text). It really should have a one-step shortcut, but to my knowledge, it doesn't. Here's my workaround: Select cell in question, hit any character to replace contents of the cell. Then hit ⌘Z to undo and boom, contents selected without any formatting! A one-step shortcut workaround will require more effort, but can be achieved with the following Keyboard Maestro macro.
Highlighting In Word 2013
This solution IS an excellent workaround, but I can't get it to work on my Excel 2007. Looks like the 'ctrl+c' action used during the macro recording isn't saved. Convert image to text ocr.
(A dummy macro emptying my cell works perfectly, but one copying contents doesn't). Also, I recorded my macros to my 'personal workbook', since I didn't want my macro sepecific to one file, but. I can't even delete them now. Text import wizard download. Hell, I just would like to select my cell's contents.
Giving up for the moment, my nerves need some rest. – Jan 4 at 10:44.