
The Style section allows you to choose one of the predefined slicer styles. If you increase the button height, the scroll bar will be added to the slicer: If you increase the button width, the slicer width will change correspondingly. If your items contain short text, you can change the column number to 2 or more:

By default, a slicer contains one column. The Buttons section allows you to specify the necessary number of Columns and set the Width and Height of the buttons. When this option is checked, the Width, Height, Position, and Buttons options are disabled. The Disable resizing or moving option allows you to prevent the slicer from being moved or resized. The Position section allows you to change the Horizontal and/or Vertical slicer position. If the Constant proportions button is clicked (in this case it looks like this ), the width and height will be changed together preserving the original slicer aspect ratio. The Width and Height options allow you to change the width and/or height of the slicer. You can hide or display this tab by clicking the icon on the right. Some of the slicer settings can be changed using the Slicer settings tab of the right sidebar that will open if you select the slicer with the mouse. To clear the slicer filter, use the Clear Filter icon in the upper right corner of the slicer or press Alt+C. Select necessary slicer buttons clicking them one by one. To select multiple slicer buttons, use the Multi-Select icon in the upper right corner of the slicer or press Alt+S. You can adjust the way to display items with no data in the slicer settings. When one or more filters are applied to a slicer, items with no data can appear in a different slicer (with a lighter color): If you have added several slicers, the changes made in one slicer can affect the items from another slicer. When you click a slicer button, other buttons will be unselected, and the corresponding column in the source table will be filtered to only display the selected item: The buttons corresponding to empty cells are marked with the (blank) label. Once the slicer is added, you can change its size and position as well as its settings.Ī slicer contains buttons that you can click to filter the table. If you add several slicers, they will overlap each other. check the required columns in the Insert Slicers window.Ī slicer will be added for each of the selected columns.The Insert Slicers window will be opened: Of course, unlike my imaginary app, Excel does exist so you might simply switch screens to Excel during your presentation instead.Slicer button. You could do the same with multiple screen shots of your Excel screen to simulate what happens when a slicer filter is applied. The presentation was so well received that the client wanted the app the next day – I found it hard to convince them that it hadn’t yet been created. I had to rehearse the presentation really carefully because, of course, the Reports menu would have dropped down wherever I clicked – but I clicked in the right places and provided a very good simulation of how the application would work once developed.

I simulated clicking menu items by creating a sequence of slides containing several perfectly aligned screen shots of the user interface so that, for example, when I clicked on the Reports menu a drop-down magically appeared.
Excel slicer demo software#
I once did a product demo (to an international audience in Rome) of some software that had been designed but didn’t exist.
