Edit, filter, and sort a Sheet

Edit cells and rows

Select a cell and edit its typed value. Select the relevant rows for a bulk action. Use Undo (Cmd/Ctrl+Z) and Redo (Cmd/Ctrl+Shift+Z or Cmd/Ctrl+Y) for committed Sheet edits; an open text editor retains its own editing history. Undo does not guarantee that later collaborator edits can be reversed.

Use column menus to insert, rename or configure fields. Pinning a column is your personal viewport preference. Column widths and underlying data are shared.

All rows and saved views

The permanent All rows tab keeps the complete table available. Filtering, sorting or changing column visibility from All rows creates a saved view. This preserves a way back to the full dataset.

Each saved view has its own filters, sorting, column order and hidden columns. Those settings are shared for people using that view; changing one view does not replace every view's filters. Rename, reorder or delete a saved view from its tab menu. Deleting a view does not delete its rows.

Filter and sort

Open Filter, choose a column and operator, then enter the required values. Operators depend on type: number/date ranges, select options and text matches use different controls. Set ascending or descending sorting from the column controls.

Switch to the relevant view before changing its filters or sort. Clear search and inspect All rows before concluding that data is missing. Shared changes can affect collaborators using the same view.

Show and arrange columns

Open Columns to search fields, toggle visibility or drag their order. The column menu can also hide a field in the current view. Hidden fields stay stored and remain accessible; hiding is not a sharing restriction. Column order and visibility belong to the saved view, while data remains one shared Sheet.

Find rows or other Sheets

The Sheet's search narrows visible rows. Workspace search is the magnifying-glass button next to New Sheet in the sidebar; it finds Sheets, row matches, actions and documentation. See Workspace search.

Review a sample of the selected rows before a bulk edit or enrichment. See Columns and History and recovery.