Loading
Prepare for Email to Become the Default Login ExperienceRead More
Quip
Add Lists in Spreadsheet Cells

Add Lists in Spreadsheet Cells

Format a Quip spreadsheet cell as a bulleted list, a numbered list, or a checklist. You can include one list type per cell.

Required Editions

Available in: Quip desktop app and Quip on web
Action Instructions
Add a bulleted list.
  • Spreadsheet Toolbar: From the spreadsheet toolbar, select the format menu, and then choose Bulleted List.
  • @Mention: @Bulleted List
  • Keyboard Shortcut: Command+Shift+8 (Mac), Ctrl+Shift+8 (Windows)
Add a numbered list.
  • Spreadsheet Toolbar: From the spreadsheet toolbar, select the format menu, and then choose Numbered List.
  • @Mention: @Numbered List
  • Keyboard Shortcut: Command+Shift+7 (Mac), Ctrl+Shift+7 (Windows)
Add a checklist.
  • Spreadsheet Toolbar: From the spreadsheet toolbar, select the format menu, and then choose Checklist
  • @Mention: @Checklist
  • Keyboard Shortcut: Command+Shift+9 (Mac), Ctrl+Shift+9 (Windows)
Add a new item in a list.

While editing list contents in a cell, use a keyboard shortcut.

  • Option+Return
  • Alt+Enter (Windows)
Check or uncheck a checklist item.

While editing a checklist in a cell, use a keyboard shortcut.

  • Command+Return (Mac)
  • Ctrl+Enter (Windows)
Change a list type in a cell. Use your cursor to select a cell, and then choose a new list type from the format menu in the toolbar. To change the list type while editing cell contents, use the list type's keyboard shortcut.
Paste a list from a Quip document into a spreadsheet cell.

Copy the list from the Quip document, double-click a cell in the spreadsheet to edit its contents, and then use a keyboard shortcut to paste. Lists with more than one hierarchy level convert to a single level in the cell.

If you don't double-click to edit a cell's contents, the list pastes into separate cells.

Paste a list from a spreadsheet cell into a Quip document.

Copy a single cell that contains a list, and then paste it into the Quip document.

If you copy more than one cell, the cells paste into a Quip document as an embedded spreadsheet.

Limitations for Lists in Cells

These actions aren’t supported for lists in spreadsheet cells.

  • Changing horizontal text alignment in cells with lists.
  • Dragging to reorder list items in a cell.
  • Customizing numbering in numbered lists.
  • Indenting lists in cells.
 
Loading
Salesforce Help | Article