Direct cell references in Excel link one cell to another using the column and row header labels. For example ... There, select the design that works best for you. Now, use the Create Table ...

For that, click on the header or footer section on a page, and click on the Design tab, as visible on the top. Then, choose a type of header and footer from the Header & Footer Elements section.

Figure A shows an example of what often happens when header text exceeds the actual data in the column. What you can’t see is that the data range extends to column P–you’re missing a lot.