We designed Quip Spreadsheets to be a completely different approach to a familiar product: integrated, collaborative, and easy to edit on any device.
Based on feedback from people who have been using Quip Spreadsheets since launch, we've added a bunch of new features to make the experience simpler and more powerful.
Mentions and Images in Cells
You can now @-mention people and documents within any spreadsheet cell. When you @-mention someone in a spreadsheet, they'll get a notification, which makes spreadsheets a great project management tool. For example, check out the employee work schedule below: With @-mentions, employees are notified when they're scheduled to work a shift.
It's also now possible to insert images into cells, which makes spreadsheets an effective tool for an employee directory or a product inventory.
Expanded Paste Options
There are several new paste options available in Quip Spreadsheets. When you paste data into a spreadsheet, a paste menu will appear in the toolbar. You can then select from a list of options which include: transposing data from row to column (or vice versa), paste values only to carry over the result of a calculation without the formula, or link cells which enables you to use the paste option to carry over all the properties of the copied cell into a different table.
We added a bunch of keyboard shortcuts to help you work faster. The new ones include:
(⌘ = Ctrl on Windows)
- ⌘-←, ⌘-→ , ⌘-↑, ⌘-↓ — Move to edge of the section
- ⌘-Shift-←, ⌘-Shift-→ , ⌘-Shift-↑, ⌘-Shift-↓ — Expand the selection to the edge of the section
- Shift-Space — Select row
- Ctrl-Space — Select column
- Ctrl-D — Fill selection down
- Ctrl-R — Fill selection right
- ⌘-Backspace — Scroll focused cell into view
- Ctrl-I — Insert above current selection
- Ctrl-; — Insert current time
- ⌘-; — Insert today's date (Ctrl-: on Windows)
See the full list of shortcuts here, or type “⌘-/” on Mac or “Ctrl-/” on Windows in Quip to see a full list of shortcuts available.
Mobile Cell Selection
It's now much easier to select a range of cells on phones and tablets. To select a range, tap and hold the first cell in the range until it glows, then tap the cell at the end of the range.