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
- 397 reads

Recent comments
1 day 57 min ago
1 day 7 hours ago
1 day 12 hours ago
1 day 20 hours ago
1 day 20 hours ago
1 day 20 hours ago
1 day 21 hours ago
1 day 22 hours ago
4 days 6 hours ago
5 days 19 hours ago