Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table Help Excel 2007
Is there a way I can Hide some data in Pivot table.
I have 3 Rows of column that I pivot but I want only one row to show without anyone having access to the filter option in the "Value field setting Menu". I use Excel 2007 please all help totally appreciated. Also can I put 2 pivot tables in one worksheet? Please let me know if I can and how to do this. Thanks a Big Bunch. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table Help Excel 2007
Hi,
I'm not sure what "I 3 rows of column means"? You can hide any row in Excel by right-clicking the row number and choosing Hide. You can protect the spreadsheet so that the user can't use any part of the pivot table, only view it. But you can't just disable a filter. You can put as many pivot tables into one sheet as you want. When you click Insert, Pivot Table, choose Existing Worksheet and click in the Location box and click the sheet tab and cell address where you want to put the pivot table. If this helps, please click the Yes button, Cheers, Shane Devenshire "Yossy" wrote: Is there a way I can Hide some data in Pivot table. I have 3 Rows of column that I pivot but I want only one row to show without anyone having access to the filter option in the "Value field setting Menu". I use Excel 2007 please all help totally appreciated. Also can I put 2 pivot tables in one worksheet? Please let me know if I can and how to do this. Thanks a Big Bunch. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007????? | New Users to Excel | |||
Pivot Table in Excel 2007 | New Users to Excel | |||
Excel 2007 - Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) |