ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot Table question-formatting (https://www.excelbanter.com/excel-worksheet-functions/138992-pivot-table-question-formatting.html)

Jon Dow[_2_]

Pivot Table question-formatting
 
I made a pivot table that has the month in the column, name in the rows going
down, and a sum of loan amounts in the main body. The problem is that It
shows the following:

A3-Amt (which is what I want)
A4-Row Labels (I want to get rid of this text)
B3-Column Labels (I want to get rid of that text too)

How do I get rid of the text in A4 and B3. It is making those column widths
way to big and I do not need to see that. I am using Excel 2007. Thanks.




All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com