Google-sheets – Copying a cell with partial formatting of text

google sheets

I have a cell in Google Sheets with formatted text content. Something like this:

You must complete both parts of the assignment.

If I copy that cell into another cell, the bold formatting is lost. Is there a way to copy both the content and the formatting?

Best Answer

Partial formatting of cell text is a recent addition to Google Sheets, and it is still pretty fragile. The following works:

  1. Select a cell
  2. Press Ctrl-C (or Command-C)
  3. Select another cell
  4. Press Ctrl-V (or Command-V)

Other methods, described below, are not as successful.

If one double-clicks a cell, selects all of its content, and copy-pastes that, the partial formatting may or may not be preserved (depending on the previous state of clipboard).

If one double-clicks a cell, selects some of its content, and copy-pastes that, the partial formatting is not preserved.

Related Topic