The Table Header Row is a crucial feature of Spreadsheet.com for designating table and header regions in a worksheet. The table header row is also used to set column names and to note where to start sorts and filters. While the table header row cannot be deleted, it can be changed. Change the header row if you have a new row you want to use for column names, or if you have added more header data and now want the table data to start lower in your worksheet.
How to Change the Table Header Row
Changing the table header row will change the column names for your worksheet, as well as the data type of the new table header to the text data type. Before you set the new table header row, make sure the cells in the row are already of the text data type.
To change the table header row, select the new row you would like to switch to, right-click on the row header for that row, and select Set as table header.
For more about the features and uses of the table header row, check out our article on the table header row and table header region. Or, for the the table header row's column counterpart, check out our article on the Primary Column.