---
schema_version: "1"
id: 877e126046b1446612d3a619c8a34c411e5752e40fe71a41211f2db9ca8c081a
title: Spreadsheets
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/quip_spreadsheets.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.quip_spreadsheets.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e5ea4b3a5860a149b48c64b2a12ceb1f973104073c0a4c350915da7214c4385c
description: Organize your data in spreadsheets, and view it in context in Quip documents.
products:
  - Quip
  - Cross Cloud
release: "264"
---
# Spreadsheets

Organize your data in spreadsheets, and view it in context in Quip documents.

- **[Edit and Format Cell Values](https://help.salesforce.com/s/articleView?id=xcloud.quip_edit_and_format_cell_values.htm&release=264.0.0&type=5)**  
    Change the look of spreadsheet cells, and update cell content.
- **[Use Data Validation in Spreadsheets](https://help.salesforce.com/s/articleView?id=xcloud.quip_data_validation.htm&release=264.0.0&type=5)**  
    Apply data validation to a cell or series of cells to keep data in your spreadsheets consistent.
- **[Apply Conditional Formatting in Spreadsheets](https://help.salesforce.com/s/articleView?id=xcloud.quip_use_conditional_formatting.htm&release=264.0.0&type=5)**  
    Automatically highlight cells that meet certain conditions or match specific values.
- **[Reference Data in Spreadsheets](https://help.salesforce.com/s/articleView?id=xcloud.quip_spreadsheet_reference.htm&release=264.0.0&type=5)**  
    Show the values in a cell, range of cells, or sheet from one spreadsheet in another spreadsheet. Referenced data retains the source formatting, and it refreshes automatically when you load the spreadsheet or when the source data is updated.
- **[Lock Data in Quip Spreadsheets](https://help.salesforce.com/s/articleView?id=xcloud.quip_lock_spreadsheets.htm&release=264.0.0&type=5)**  
    Lock individual cells, a spreadsheet tab, or an entire spreadsheet to prevent accidental edits to spreadsheet data. Locking spreadsheet data prevents you and other users from making edits.
- **[Sort and Filter Spreadsheet Data](https://help.salesforce.com/s/articleView?id=xcloud.quip_filter_spreadsheet_data.htm&release=264.0.0&type=5)**  
    See only the data that you want to see with filters and filter views. Sort to see your data how you want to see it.
- **[Add Lists in Spreadsheet Cells](https://help.salesforce.com/s/articleView?id=xcloud.quip_lists_in_spreadsheet_cells.htm&release=264.0.0&type=5)**  
    Format a Quip spreadsheet cell as a bulleted list, a numbered list, or a checklist. You can include one list type per cell.
- **[Add Formulas and Functions to a Spreadsheet](https://help.salesforce.com/s/articleView?id=xcloud.quip_spreadsheet_formulas.htm&release=264.0.0&type=5)**  
    Use functions to create formulas and perform calculations on your data.
- **[Create Charts with Spreadsheet Data](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_spreadsheet.htm&release=264.0.0&type=5)**  
    Turn any range of your spreadsheet data into a chart. Charts dynamically update to reflect changes to your spreadsheet data.