Rich text formatting in a Google Sheets cell

Question

How is it possible to enable "rich text formatting" inside a single Google Sheets cell?

I'd like to have a cell containing some text with both bold and non-bold content, words in italic, with some hypertext links, etc.

How to do this with Google Sheets?

---

Example: When I copy paste:

This is a test. This text is bold or italic.

into a Google Sheets cell, the formmating is lost: only italic is kept but for the whole cell.

As a comparison, when I copy/paste it into an Excel cell, the formatting is ok:

Answer 1

Rich-Text formatting is not an OPT in/out / turn on/off feature. It's always turned on. To use it:

1. Put the cell in edit mode
2. Type the text
3. Select the text part to apply bold, italics, color
4. Apply the desired format by using the Google Sheets toolbar or keyboard-shortcuts like Ctrl+b for bold, Ctrl+i for italics, Ctrl+k to insert a link, etc.
5. Put the cell in display mode (press Enter, click the Tab, etc.)

Notes:

1. If copy-paste is not working and you aren't using Chrome it's very likely that format that is failing is an unsupported feature for the Operative System / web browser that you are using, if it's not working in Chrome stable channel, the it's very likely that it's a bug.
2. In Google Sheets cells, the Rich-Text formatting options are limited, no in-in-line hyperlinks, no in-line images.

Related

• A Way to Add Text Before Your Hyperlink in Google Spreadsheets?
• Is it possible to have plain text and a link in the same cell?

Resources

• Edit & format a spreadsheet
• Keyboard shortcuts for Google Sheets
• Work with links, bookmarks, section breaks, or page breaks