Rich Text

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.

rich-text-dialog.png

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.

rich-text-sample.png

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.

floating-toolbar.png

  1. Headers: Select a header format from the dropdown
  2. Format: Apply bold, italic, and strikethrough formatting
  3. Hyperlink: Turn a selection of text into a clickable link
  4. Lists: Create a checklist, numbered list, or bullet list within the cell
  5. Blockquote: Callout text by transforming it into a blockquote
  6. 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