84. Excel Tips - Select All Text In A Cell

Here's how to select and copy all the text in a cell:
- Select the cell
- Press F2
- Press SHIFT + HOME
- From here, you can copy the contents of the cell
- If you want to copy the result of a formula, press F9 first
- Don't forget to press ESCAPE when you're finished
The reason this is useful is that sometimes when you copy a cell, doing other operations will remove the cut-copy mode and you'll lose the copy. Copying this way will retain the copy on the clipboard.
Download sheet to practise how to Select All Text In A Cell in Excel
Training Video on how to Select All Text In A Cell in Excel:
| Attachment | Size |
|---|---|
| select-all-text-in-a-cell.xls | 27 KB |
»
- Nick's blog
- Add new comment
- 2113 reads

Recent comments
12 hours 23 min ago
19 hours 40 min ago
22 hours 33 min ago
22 hours 38 min ago
1 day 13 hours ago
1 day 13 hours ago
1 day 23 hours ago
2 days 15 hours ago
3 days 15 hours ago
3 days 16 hours ago