microsoft excel slicers

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel Slicers

Microsoft Excel Slicers

resolvedResolved · 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.


 

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally 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.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips


Server loaded in 0.08 secs.