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?

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

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.

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

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.

3. Choose View More Column/Row Actions at the bottom of the menu. 4. Click Freeze Up to Column/Row [letter]. This will also freeze any columns or rows before the selected one.

If you use Excel your text will sometimes spill over. This article will show you how to get Excel cells to fit Text. Make cells expand to fit Text!

Then, select the header cells, B2:P2, and click Wrap Text in the Alignment group on the Home tab. As you can see in Figure D, you usually have to tweak a column or two–or maybe even all of them.

How to freeze the top row in Excel Keep in mind that this doesn't have to literally be the top row in your spreadsheet — this command lets you freeze the first visible row. 1. Scroll your ...

A new row has been inserted, and now you can type in “Cleaning service,” add the date if you so desire, and place the appropriate amount budgeted for the line item. When you work with an Excel ...