Sign in

Docs Help



Editing spreadsheets: About 'list view'

Print

List view is a simple, fast-loading view of a spreadsheet, with basic editing, sorting, and filtering capabilities. Here's what you can do with list view:

  • Sort and filter without modifying underlying data.
  • Get a simple view of your data with or without formatting.
  • Provide a simple method of data entry for novice users.
  • Share a read-only spreadsheet, but allow sorting and filtering.
  • View your spreadsheets on a slow Internet connection.
  • View your spreadsheets from some mobile phones.
  • Give more than 50 users access to the same spreadsheet at a time.

When you're on a slow Internet connection, you'll see a prompt to use list view. If you're trying to access a spreadsheet with more than 50 users currently viewing it, you'll be automatically redirected to list view.

To access list view from your desktop computer, go to the View menu in your spreadsheet and select List view.

List view

If your phone has Webkit-based browser (iPhone, Android, Nokia S60, Palm Pre), you'll be able to access list view and edit your spreadsheets from your mobile phone. Just go to your mobile Docs list at http://docs.google.com/m.

You can bookmark or share any list view URL for quick access later. All editing and viewing permissions set in the Share menu apply to list view just as they do to normal spreadsheet view.

List view provides a few basic ways to manipulate data:

  • edit cells
  • add rows
  • filter and sort data (won't permanently affect the spreadsheet)
  • add formulas (you won't be able to edit cells with formulas while in list view)
In list view you can't select cells, rename sheets, format data, use auto-fill, edit formulas, add comments, add new collaborators and viewers, or insert images, charts and gadgets. But you can always switch back to normal spreadsheet view by clicking the Go to spreadsheet view link.
Was this information helpful?

Docs for teachers and businesses

Docs for business

Docs for teachers

Adding Docs to a Website

Sounds great! Tell me more.