ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Change Pivot table text for totals & col headers? (https://www.excelbanter.com/excel-worksheet-functions/71852-change-pivot-table-text-totals-col-headers.html)

Sue

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