Headers and footers in a worksheet - Microsoft Support
Add or change headers and footers in Excel. Add the date, time, page numbers, filename or any other text.
Turn Excel table headers on or off - Microsoft Support
In the Table Style Options group, select the Header Row check box to hide or display the table headers. If you rename the header rows and then turn off the header row, the original values …
Format text in headers or footers - Microsoft Support
You can change the font, style, and size of the headers and footers that you want to print with along with contents of your worksheet. Also, there are options you can configure to ensure that …
Set up your header row - Microsoft Support
To rename the columns, double-click each column header and type the name you want or edit an existing one. To return the transformed data to the Excel worksheet, select Home > Close & …
Transpose (rotate) data from rows to columns or vice versa
How to use Transpose in Excel to rotate columns and rows to rearrange your worksheet data.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Insert page numbers on worksheets - Microsoft Support
Add page numbers or other text to a header or footer. Learn what a header and footer is, and how to find them in Excel.
Using structured references with Excel tables - Microsoft Support
When you create an Excel table, Excel assigns a name to the table, and to each column header in the table. When you add formulas to an Excel table, those names can appear automatically as …
Fit more text in column headings - Microsoft Support
Rotate text and borders in column headings You can angle text to fit long headings into small columns. Select the cells that you want to format. On the Home tab, click Format, and then …
Repeat specific rows or columns on every printed page
When an Excel worksheet spans more than one page, you can print row and column headings (also known as headers or labels) on every page.