+ Reply to Thread
Results 1 to 9 of 9

How to change the position of slicer headers?

  1. #1
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    How to change the position of slicer headers?

    Hi there,

    I have created a slicer with calender months.
    How do I change the layout of them to be in month order?
    By right clicking, I only get the option of ascending / descending order?
    Or use custom lists when sorting. But where can I see this?

    Thanks and Regards

    N

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: How to change the position of slicer headers?

    Are they real date months or text/numbers that look like months?

    If they are dates then the months should be in month order in the slicer.

    Can you attach a sample?

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to change the position of slicer headers?

    There is a check box on the slicer properties dialog to use Custom lists for sorting, so even if months are just text you can get the order you want.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    Re: How to change the position of slicer headers?

    Hi there,
    Thanks for your ideas.
    There is a formula in the cells that is being used for the pivot table / slicer : TEXT(= A1,"mmmm yy")

    I have tried the custom lists but this does not work?

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to change the position of slicer headers?

    Why not just reference the cell and then apply a custom number format?

    Your custom list would only work if you have defined a custom list made up of month year combination

  6. #6
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    Re: How to change the position of slicer headers?

    Hi Andy,
    Hope you are well?
    Not sure how to do this and if it will work.
    Please can you advise on hoe to reference the cell and apply the custom number format?
    Even if I select the check box for custom number format, you still have have to either select ascending / descending order, which seems to take priority?

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to change the position of slicer headers?

    See attached example
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    01-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    147

    Re: How to change the position of slicer headers?

    Hi Andy,
    I appreciate your help. Unfortunatley, I cannot see the slicer in the attached example.
    There is text saying 'if the shape was modified in a earlier version of excel or if the workbook was saved in excel 2007 or earlier, the slicer can't be used'?

    Regards

    N

  9. #9
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to change the position of slicer headers?

    Even if you can not see the slicer you can see the number format applied to the column.
    What happens if you add a slicer to the table?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Setting the size and position of a slicer based on Formula Name
    By JimmyA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2018, 07:08 AM
  2. Loop through slicer, while also selecting single slicer value on separate slicer
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2018, 01:41 PM
  3. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  4. [SOLVED] vba code to merge headers from 2 sheets at their specific columns position 3rd sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2017, 11:41 PM
  5. Slicer Change Event
    By DuncR6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2013, 04:59 AM
  6. [SOLVED] change the position of colum headers from A1 > A5 to A1 > E1
    By tigerpie in forum Excel General
    Replies: 3
    Last Post: 02-12-2013, 08:13 AM
  7. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1