| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Office 07, how do I format my pivot table data?
In the previous version, once I got all of my data into the table the way I
wanted, there was a button on the pivot tool bar that I clicked that would give me a list of report formats. I cannot find anything similar in 07 so I'm having trouble formatting. I have tried all of the options and cannot figure out how to show that data the way I need to. Does anyone know if there is an alternative for the old "report" button? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Office 07, how do I format my pivot table data?
The old pivot table report styles aren't available in Excel 2007.
Select a cell in the pivot table, then on the Ribbon's Design tab, you can select a Report Layout and a PivotTable Style. Razzberryzing wrote: In the previous version, once I got all of my data into the table the way I wanted, there was a button on the pivot tool bar that I clicked that would give me a list of report formats. I cannot find anything similar in 07 so I'm having trouble formatting. I have tried all of the options and cannot figure out how to show that data the way I need to. Does anyone know if there is an alternative for the old "report" button? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Format from Source Data | Excel Discussion (Misc queries) | |||
| Office 2003 pivot table filter data values | Excel Discussion (Misc queries) | |||
| Format Extracted Data from Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table format changes when data is refreshed | Excel Discussion (Misc queries) | |||
| Pivot table format changes if value of source data is null | Excel Discussion (Misc queries) | |||
Linear Mode
