The Table Header Row divides your worksheet into two regions: a Header region and Table region.
Spreadsheet.com worksheets can be divided into two regions: a Header region and Table region, with the Table Header Row separating the two. Both regions are made up of the typical spreadsheet cells, but only rows in the Table region are treated as records when performing actions like sorting, filtering, or creating a Kanban View.
The Table Header Row is denoted by a table icon to the left of the row index. Rows above the Table Header Row make up the Header region; rows below the Table Header Row make up the Table region.
Headers can be used to display important project information, summary statistics, charts, images, instructions, and more. Take a look at some of these Header examples:
How to Set the Table Header Row
- Right-click the row index on the left side of the browser window
- From the dropdown, select Set row as the table header
Column headers at the top of your worksheet adopt their names from the text found in cells in the Table Header Row. When you organize your worksheet with sorting, filtering, or grouping, only records in the Table region will be affected. The same applies when creating a Gantt, Calendar, Kanban, or Form View.
Worksheets do not need to have a Table Header Row, and the Table Header Row can be added, removed, or changed at any time.
Learn More: The Table Header Row
For a closer look at the Table Header Row, take a look at these resources:
- “The Table Header Row and Table Region” – Learn more about what you can do with the Table Header Row and Header region
- “Changing the Table Header Row” – Learn more about changing the row designated as your Table Header Row
Next, we’ll explore Data Types, a key concept for working with data in Spreadsheet.com workbooks.