Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
column width
Hi all,
here's my dilemma: I have a worksheets that has some dollar amount spend on consultants and the month in which the charges were incurred. I set up a pivot table in which I put the month field in the Page area and the dollar amounts inthe data area of the pivot table. On the columns area, I put the various consultant names, some of long names, so what I did was have the cells wrap around. After the pivot table is created, a drop is created by the pivot tabel wizard which list all of the months, so that I can select a particular month and see only that month's expense. But happens is when I changed the month in the drop down box for the very first time, the columns in that contains the name of the consultants (that is the column area of the pivot table) expands, and looses the wrap text feature, and then I have to re-adjust the columns again, but if I change to a different month, the columns would expand again. It's really annoying. I tried the enable selection option and it does not work. Please share with me any suggestion you may have, so I can remedy this. Thanks so much. Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |