This is one hell of a problem in formatting, as the normal “Ctrl + A” doesn’t work.

Faced the problem myself, searched the internet, and didn’t discover a proper answer.

Experimented and found a solution myself. Thought to share with all.

So here it is –

Selecting all contents in a cell

  1. Edit the cell (Double click/ F2)
  2. Press “Ctrl + Home”
  3. Press “Ctrl + Shift + End”

Congratulations! You have selected everything. Now cut/ copy as required. 🙂