How Do You Create a Header Row & Description Row in an Excel Spreadsheet?. Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, also called description rows.

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

Can Excel show column headers on every screen? Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple.

However, you don't need to take this step if you format your data as an Excel table. To do this, first, make sure your data has column headers in the top row.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

The header for both the row and column on the spreadsheet will hide, showing cells instead. The other option to hide the row and column headers in Excel is to click the File tab.