Setting a table header row allows you to differentiate between the table and header regions of your worksheet. Set and unset the table header row to change where your table data starts, which row is used to name your columns, to create a header region for summary data, and more.
How to Set a Row as the Table Header
To set a row as the table header row, select the desired row and right-click on the row header. From the menu options that appear, click Set row as table header.
After setting a row as the table header, three changes occur simultaneously. A database icon will appear next to the Row's number in the row header , the column names will change to match the corresponding titles in each column of your table header row, and all cells in the table header row are converted to the Text data type, even for columns with strict column data validation.
How to Unset the Table Header Row
Users cannot delete the table header rows. However, you can unset the table header row either by Changing the table header row or unsetting the table header row. To unset the table header, first select the table header, then right-click, and select Unset row as table header from the menu.
For more on what the table header row and table header region enable, including the effect on sorts and filters, check out our Table Header Row and Table Header Region article.