Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

The cell will appear blank and the PivotTable will no longer display (blank) in the grand total rows. Figure I shows the new grand total text, sans (blank) and the Currency format in the amount field.