Using structured references with Excel tables - Microsoft Support
Column specifier: [Sales Amount] and [Commission Amount] are column specifiers that use the names of the columns they represent. They reference the column data, without any column header or total row. Always enclose specifiers in brackets as shown.
Headers and footers in a worksheet - Microsoft Support
For worksheets, you can work with headers and footers in Page Layout view. For chart sheets or charts, you can work with headers and footers in the Page Setup dialog box. Select the worksheet to which you want to add specific header or footer elements.
Print rows with column headers on top of every page
If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages when you have large, complex worksheets.
Print row and column headings - Microsoft Support
By default, Excel doesn't print the column headings (A, B, C, etc.) or row headings (1, 2, 3, etc.) that appear along the borders of the sheet. Follow these steps to print the column and row headings for a worksheet:
Repeat specific rows or columns on every printed page
If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles. Follow these steps to add Print Titles to a worksheet:
Promote or demote rows and column headers (Power Query)
When a table is created, Power Query often automatically detects column headers and promotes them if necessary. However, you can also promote a first row to column headers or demote column headers to the first row when you need to.
Turn Excel table headers on or off - Microsoft Support
When you first create a table, you have the option of using your own first row of data as a header row by checking the My table has headers option: If you choose not to use your own headers, Excel will add default header names, like Column1, Column2 and so on, but you can change those at any time.
Work with a List, Record, or Table structured column (Power Query ...
Structured columns have an Expand icon in the column header. Stores a list of values, For example, { 1, 2, 5, 10 } or { "hello", "hi", "good bye" }. A value of in a cell is the simplest structured column and there is no table relationship. Stores a set of named fields grouped into a unit.
Use a screen reader to create column headers in a table in Excel
Use Excel with your keyboard and a screen reader to create descriptive column headers in an existing table. We have tested it with Narrator, JAWS, and NVDA, but it might work with other screen readers as long as they follow common accessibility standards and techniques.
Format an Excel table - Microsoft Support
You can further adjust the table formatting by choosing Quick Styles options for table elements, such as Header and Total Rows, First and Last Columns, Banded Rows and Columns, as well as Auto Filtering.
Print the top row on every page - Microsoft Support
In a worksheet that will take more than one page to print, you can print column headers on each page so the column headings can be seen on each page. On the Page Layout tab, in the Page Setup group, click Print Titles .