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 ...

To turn your big data set into a PivotTable, select any cell in the range, and in the Insert tab on the ribbon, click the top ...

Type a header name in the top cell of each column, for example "Name," "Address" and "Phone Number." Highlight the row that contains the headings that you want to be able to sort.

Before clicking OK, specify whether the data set has a header row. By default, Excel assumes the first row of data is a header row. Click OK to convert the data set into a table.

You will definitely need to copy the "group" header info into fields for each row, or else you'll lose that information if you try to sort it.<BR><BR>Are you averse to using/writing a macro?

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 ...