The Rich Text data type gives you more control over the appearance of a cell’s text, with support for lists, inline code blocks, checkboxes, and more.
Using the Rich Text data type gives you more options for configuring the appearance of text within cells. Cells set to the Rich Text data type support…
- Numbered lists
- Bulleted lists
- Checklists
- Code blocks
- Inline code blocks
- Blockquotes
…as well as bold, italic, and strikethrough formatting. In the image below, Cells C5 and D5 use the Rich Text data type.
Text can be configured with the floating toolbar above a Rich Text cell, or by applying markdown syntax. Markdown is a markup language used to format text by using a specialized syntax. It is commonly used in text editors. Using markdown language lets you change the size of text, apply bold formatting, strikethrough or italicize text, and more.
Changing Text Appearance with the Floating Toolbar
When you double-click on a Rich Text cell to edit it, a floating toolbar will appear above the cell. Use the buttons in the floating toolbar to edit your text.
- Headers: Select a header format from the dropdown
- Format: Apply bold, italic, and strikethrough formatting
- Hyperlink: Turn a selection of text into a clickable link
- Lists: Create a checklist, numbered list, or bullet list within the cell
- Blockquote: Callout text by transforming it into a blockquote
- Code: Create an inline code snippet or code block
When you’re editing text in a Rich Text cell, pressing “Enter” or “Return” on your keyboard will create a line break. When you are done editing text, click the Done button in the bottom right corner of the cell.
Changing Text Appearance with Markdown Syntax
When a cell is configured with the Rich Text data type, you can apply markdown formatting to text within it. Spreadsheet.com supports the following markdown syntax. In each of the examples below, replace the word “text” with the text you intend to format.
Bold, Italicize, and Strikethrough
Style | Syntax |
Bold |
**text** or __text__ |
Italic |
*text* or _text_ |
Strikethrough |
~~text~~ |
Headings
Style |
Syntax |
Header 1 |
# text |
Header 2 |
## text |
Header 3 |
### text |
Header 4 |
#### text |
Header 5 |
##### text |
Header 6 |
###### text |
Lists
Style |
Syntax |
Numbered List |
1. text 2. text 3. text |
Bulleted List |
* text * text * text |
Checklist |
[] text [] text [] text |
Code
Style |
Syntax |
Inline code block |
‘text’ |
Code block |
‘’’ text ‘’’ |
Blockquotes
Style |
Syntax |
Blockquote |
> text |