+ Reply to Thread
Results 1 to 2 of 2

how to arrange slicer look from vertical to horizontal?

Hybrid View

  1. #1
    Registered User
    Join Date
    03-10-2005
    MS-Off Ver
    Excel 2013
    Posts
    95

    how to arrange slicer look from vertical to horizontal?

    hi guys,

    just need to know if we can re-arrange the slicer look from vertical to horizontal, cases is if you have like 20 items, slicer will put them into vertical

    X
    X
    X

    but sometimes it is better to do like below to reduce space

    XXX
    XXX
    XXX

    thanks for any input

    answer :

    click slicer.. then on slicer ribbon look at the very top right corner, there is column there, just make it to 2, 3 or 4 as you like
    Last edited by koi; 10-26-2012 at 04:09 AM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: how to arrange slicer look from vertical to horizontal?

    Thank you for the solution. However, it would have been good if you put it as a separate post (like post 2). So your question and answer are clear to others as well. You can do so for future threads.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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