| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Pivot table text for totals & col headers?
I am running Excel 2000 on Windows NT. Is it possible to change the column
header for the Data area? When I right-click on it, the Field Settings option is not available. But you can change the column headers for your column and row variables. Also, the final grand total row at the bottom: It says 'Total Number of Participants'. I customized the 'Number of Participants' part, but I would like it to say 'Grand total number of participants'. So I would like the grand total to have different text than sub totals. Any ideas how to do this? Thanks so much! Sue |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| How do I change the order of my pivot table? | Excel Discussion (Misc queries) | |||
| How to create a Pivot table from text file with more than 65000 rows? | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Linear Mode
