'/%3E%3Cdefs%3E%3ClinearGradient id='paint0_linear' x1='0' y1='0' x2='0' y2='2160' gradientUnits='userSpaceOnUse'%3E%3Cstop/%3E%3Cstop offset='.1' stop-color='%23000' stop-opacity='0'/%3E%3Cstop offset='1' stop-opacity='0'/%3E%3C/linearGradient%3E%3C/defs%3E%3C/svg%3E%0A)
Frame
Summary
A Frame is a table with named columns and a set of data rows.
If a cell contain a Frame data type, it can be opened in nested view.
Examples
Create a Frame in cell A6, based on a dataset from A1:B4 range.
| A | B | |
|---|---|---|
| 1 | id | name |
| 2 | 1 | Robert |
| 3 | 2 | Silvia |
| 4 | 3 | Anthony |
| 5 | ||
| 6 | =FRAME(A1:B4) |
Cell A6 now contains a nested frame:
Sheet1!
| id | name | |
|---|---|---|
| 1 | 1 | Robert |
| 2 | 2 | Silvia |
| 3 | 3 | Anthony |
Live Demo
See how to work with frames in a live demo.