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
- Login or register to post comments
- 45299 reads
m.touhey@me.com
Any idea how I would go about this function on a mac? You are the only one on the web to address a shortcut to select all within cell. Good job!
m.touhey@me.com