+ Reply to Thread
Results 1 to 2 of 2

Slicers on the ribbon

  1. #1
    Registered User
    Join Date
    10-04-2017
    Location
    Dublin
    MS-Off Ver
    Microsoft 365 Apps for Enterprise
    Posts
    34

    Slicers on the ribbon

    Hello!

    I'm looking for some help again!

    Is there is a way to add slicer buttons to the custom ribbon? I have slicer and it works perfect but it takes too much space on the screen where I need to see the information, so I was thinking may be there is a chance to locate the buttons on the custom ribbon.

    Should be something like on the picture attached, so it doesn't restrict the view on the spreadsheet...
    Slicer on the ribbon.jpg

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,483

    Re: Slicers on the ribbon

    I think that is not an option that is possible. even when googling I did not find any indication of solution like that.

    From your profile it is not clear what version you are using. When in version 2013 or above there is also a timeline as alternative
    https://support.office.com/en-us/art...d-6fc99d9fadfa

    another possible solution might be to have a small button on your sheet to show and hide slicers when you are not using them, that would need vba.
    this site describes how you can build that.
    https://www.contextures.com/excelpop...rselector.html

+ 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. [SOLVED] Customize Ribbon by XML - Restart Ribbon
    By Joakim N in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2018, 05:54 AM
  2. Using Slicers
    By JakeMann in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-29-2016, 08:50 AM
  3. Put VBA ribbon together with Custom UI Editor Ribbon
    By czarlando in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2016, 05:46 AM
  4. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  5. [SOLVED] Ribbon Change based on Non-Ribbon Object
    By diakonos1984 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-07-2014, 01:18 PM
  6. [SOLVED] An alternative to the Add-Ins ribbon tab - Global Custom Ribbon Tab by Ken Puls
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2014, 10:01 PM
  7. Ribbon - Multiple xlam adding into single Ribbon tab
    By gooopil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2011, 03:40 PM

Tags for this Thread

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