# Use the Grid view

> The Grid view shows one record per row and one field per column. Edit cells, open records, add rows and use summaries, on a computer or a phone.

Source: https://artavolo.com/page/using-the-grid-view

The Grid view shows one record per row and one field per column, like a spreadsheet. It is where most tables start, and the fastest place to type in a lot of data.

![A Tasks table in the Grid view with Status, Priority, Owner, Due, Estimate, Progress, Tags and Campaign fields](https://artavolo.com/site/templates/default/assets/img/help/grid.webp)

## Edit cells

- Click a cell and type, or press `Enter` to edit what is there. `Escape` drops the change.
- Copy and paste whole blocks of cells, to and from Excel or Google Sheets.
- `Ctrl`+`Z` undoes the last change; the arrows at the end of the tab bar undo and redo too.

## Open a record

Press `Space` on a cell, or the expand icon beside the row number, to open the record. You see every field, including the ones this view hides, and the record's **Activity**: its changes and comments. Type `@` in a comment to mention someone; they get a notification. The arrows at the bottom move to the previous and next record.

![An open record, Design hero banner, with its fields on the left and the Activity panel with a comment box on the right](https://artavolo.com/site/templates/default/assets/img/help/record.webp)

## Use the record menu

Right-click a row for its menu: expand, comment, select, insert a record above or below, duplicate, copy, paste and delete.

![The menu of a record: Expand record, Comment, Select record, Insert record above, Insert record below, Duplicate record, Copy, Paste and Delete record](https://artavolo.com/site/templates/default/assets/img/help/record-menu.webp)

## Add and remove

- **Add row** under the last record adds one. Inside a group, the **+** in the group's header adds a record that already belongs to it.
- The **+** after the last field adds a field.
- A deleted record goes to the [trash](https://artavolo.com/page/removing-a-sheet) for 30 days.

## Read the summaries

The row under the last record summarises each field. Click it to choose: sum, average, median, minimum, maximum or range for numbers, and empty, filled, unique, percent empty or percent filled for any field.

![The summary menu under the Estimate field: None, Sum, Average, Median, Min, Max, Range, Empty, Filled, Unique, Percent empty and Percent filled](https://artavolo.com/site/templates/default/assets/img/help/summary.webp)

## Shape the view

The bar above the grid holds [Hide fields](https://artavolo.com/page/hiding-columns), [Filter](https://artavolo.com/page/filtering-rows-using-conditions), [Group and Sort](https://artavolo.com/page/sorting), **Color** (colour rows by a single select field or by conditions) and **Row height** (**Short**, **Medium**, **Tall** or **Extra tall**). The magnifier finds text in the view. Drag a header's edge to resize a field, drag the header to move it, and use **Pin to left** in its menu to keep it in place while you scroll.

## On a phone

- A grid view stays a grid: scroll both ways, with the first field pinned at the left.
- Tap a cell to select it and tap again to edit it. Single select, user and date fields open a picker from the bottom of the screen, without the keyboard.
- Tap a row's number to open the record, and swipe left or right in it to go to the next or previous record. A long press on the number opens the row's menu.
- The round **+** in the corner adds a record. Menus and panels open as sheets from the bottom.

## Good to know

- What you may edit follows your role and the base's permissions. Only owners add, change or delete fields.
- Widths, field order and pinned fields are saved with the view when an owner changes them.
- While you work in a row, it stays where it is even if a sort or filter would move it; it takes its place when you move to another row.

## Related

- [Create, switch and lock views](https://artavolo.com/page/view-settings)
- [Keyboard shortcuts](https://artavolo.com/page/keyboard-shortcuts)
- [Edit, duplicate, move or delete a field](https://artavolo.com/page/duplicate-a-column)
- [Artavolo on your phone](https://artavolo.com/page/artavolo-on-your-phone)
