98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel Slicers
Microsoft Excel Slicers
Resolved · Urgent Priority · Version 2010
Kome has attended:
Excel Pivot Tables course
Excel Advanced course
Microsoft Excel Slicers
Thanks you to answers from my last questions. Was very helpful indeed.
This time i'm trying to create individual sheets from slicers. You know when you have a pivot you double click on a cell and a sheet is automatically created that shows the back up of the summary.
I'm trying to do the same for a slicer.
Thanks
RE: Microsoft Excel Slicers
Hi Kome
The good thing about Slicers is you can filter by fields that have note been added to the . This can cause a problem if you double click to see the detail. Only the fields added to the pivot table with control the items in the detail sheet. Fields in Slicers that are being use exclusively as Slicers won't apply to the detailed data sheets - so you will probably end up with more data than you wanted when you double click.
As far as I am aware in Excel 2010 the only answer is to add the field both to the pivot table and the slicers at the same time.
Let me know if you have any further questions.
Kind regards,
Andrew
RE: Microsoft Excel Slicers
Hi Kome,
When you double click on a cell within a Pivot it gives you a copy of the source data.
There isn't a way to click on a slicer button and have it generate a sheet of data.
When you create a Pivot Table if you drop the Category you would like, into the Filer box, rather than making it a slicer.
Then in the Pivot Table Tabs along the top (for 2010 users) click on Options tab.
Far left is another smaller box called Options (just below the Pivot Table Name), click the drop down arrow on the Options Button.
In that list is the Show report filter Pages
This will generate individual Pivot Tables for every Button that would have been in your Slicer.
Hopefully that helps you to generate lots of individual sheets.
Kind regards
Richard Bailey
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 30 Apr 2015: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Convert a column into row quickly in Excel 2010Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa. |