To use this tool to number rows, make the first entry in the column the row function called upon that cell itself. For example, if you have a header row as the first row in your spreadsheet and ...

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. On the backstage ...

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

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.

3. If, however, your headers are stacked in multiple cells (on multiple rows, for example), or you have a title on your spreadsheet, you’ll want to freeze more than just the top row. 4.

How to create an Excel table 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.