![]() |
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 |
All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com