Excel Slicer Horizontal: How to Arrange Buttons in Rows

How-to basics · Updated November 21, 2026

To make an Excel slicer horizontal, select it and increase the Columns setting on the contextual Slicer tab. Excel lays the slicer buttons out across those columns, then continues on the next row; widen the slicer or adjust button size to make the layout fit comfortably.

What a horizontal slicer means in Excel

An Excel slicer is a set of clickable buttons that filters a Table or PivotTable. In its default layout, the buttons commonly appear in one vertical column. A horizontal layout places multiple buttons side by side, creating a compact filter control that can sit above a chart or report.

There is not usually a separate switch named Horizontal or an orientation option that rotates the slicer. Instead, the Columns value determines how many button columns the slicer uses. For example, a slicer with four columns can display four category buttons across a row when there is enough room. If there are more categories, Excel continues on subsequent rows.

This is different from rotating text or turning the whole slicer object sideways. The slicer remains a rectangular object; its buttons are arranged in a grid. Understanding that distinction helps when you are trying to make a dashboard filter look like a horizontal strip.

Set the slicer buttons into columns

These steps apply to Excel for Microsoft 365 on Windows. First, click the slicer itself so Excel displays the contextual Slicer tab. If you click a button inside the slicer without selecting the object, the contextual tab may not appear; click the slicer border or its outer area instead.

  1. Select the slicer you want to change.
  2. Open the Slicer tab on the ribbon.
  3. In the Buttons group, locate Columns.
  4. Enter a number greater than 1, or use the control arrows to increase the value.
  5. Resize the slicer if necessary so the buttons have enough room to display.

For instance, suppose a slicer has six region buttons: North, South, East, West, Central, and Online. Setting Columns to 3 arranges the buttons in three columns, typically producing two rows. Setting it to 6 may put all six on one row, provided the slicer is wide enough and the button labels fit.

The row count is not a separate setting you need to calculate. It depends on the number of items and the number of columns, as well as the space available. If a row looks incomplete, the final row may simply contain fewer items than the others.

Choose a useful number of columns and size

The right column count depends on both the number of slicer items and the available dashboard space. A high column count makes the slicer shorter, but it also makes each button narrower. Long labels may be clipped, and a user may have trouble identifying a choice quickly. A low count gives labels more room but uses more vertical space.

Use a few practical checks while adjusting it:

  • Count the choices: If a slicer has eight short labels, four columns may create a balanced two-row grid. If it has five choices, three columns may make a tidy two-row arrangement.
  • Read the longest label: Make sure a button can show the full text or enough of it to remain unmistakable.
  • Consider the whole report: Leave space around the slicer and avoid covering chart titles, totals, or other controls.
  • Check at normal viewing size: A layout that looks fine while zoomed in may become crowded when the workbook is viewed at its usual zoom.

You can resize the slicer by dragging its sizing handles. The Slicer tab also provides controls for button dimensions and object size in versions where those controls are shown. Button width and height affect the individual choices, while changing the slicer object’s width affects how much room the grid has. If the buttons appear cramped, try a wider slicer or fewer columns before reducing text size.

Use a horizontal slicer in a Table or PivotTable

Slicers can filter Excel Tables and PivotTables, but the source determines how the filter behaves. For a Table, select a cell in the table and use Insert > Slicer, then choose the field you want to filter. For a PivotTable, select a cell in the PivotTable and use PivotTable Analyze > Insert Slicer. After insertion, select the slicer and change its column count on the Slicer tab.

A horizontal arrangement can be useful for fields with a modest number of familiar categories, such as department, quarter, or sales region. A row of quarter buttons above a chart, for example, lets someone switch between Q1, Q2, Q3, and Q4 without taking up a tall strip along the side of the report. A field with dozens of products may be less suitable: it could require many rows or very narrow buttons, so a search-enabled filter or a different report design may be easier to use.

If a report contains multiple PivotTables, do not assume that one slicer filters all of them automatically. Select the slicer and look for Report Connections (called PivotTable Connections in some versions or contexts) to choose compatible PivotTables. The PivotTables generally need to share an appropriate data source or cache. Changing the slicer’s columns only changes its appearance; it does not change which reports it filters.

Make the layout clear and accessible

A compact filter bar is helpful only if its choices remain easy to understand. Use concise field names and consistent labels. If button labels are abbreviations, explain them in a nearby note or use clearer source values. Avoid relying on color alone to signal which buttons are selected: slicers show selection states, but users should also be able to recognize the text and understand what the filter field represents.

For a dashboard with several slicers, keep related controls together and use consistent dimensions. For example, place Year and Quarter beside each other, but do not force a long list of customer names into the same narrow horizontal strip. A useful layout might keep short, high-level filters horizontal while leaving a longer category slicer vertical. The point is not to make every slicer horizontal; it is to make the important controls easy to find without overwhelming the report.

Test the control after arranging it. Click a few buttons, clear the filter, and verify that the charts or totals respond as expected. If the workbook will be shared, consider whether a reader can distinguish selected items from unselected ones and whether the slicer is large enough to click comfortably.

Common problems and how to fix them

The Slicer tab is missing. Click the slicer object’s border, not a worksheet cell or the button text alone. The tab is contextual and appears when the slicer is selected. If you are working in Excel for the web or on a different platform, ribbon options may differ; open the workbook in the desktop Excel app if you cannot find the layout control.

The buttons still look vertical. Confirm that Columns is greater than 1. Then widen the slicer. If the object is too narrow for the chosen number of columns, the buttons may be squeezed or the intended grid may not be visually apparent. Also check that you changed the slicer you meant to change when a worksheet contains several slicers.

Labels are cut off. Reduce the number of columns, widen the slicer, or shorten the underlying category names where appropriate. Increasing button width can help if that control is available. Do not assume that a higher column count always means a better horizontal design: narrow buttons can make a filter harder to use.

The slicer is too tall. Reduce the number of rows by increasing Columns, provided the buttons remain readable. You can also reduce button height if the labels still fit. A field with many unique values may remain tall even after adjusting the grid; in that case, consider a different filtering method rather than squeezing every choice into a small area.

A slicer does not filter a chart or another PivotTable. Check that the chart is based on the filtered data and inspect the slicer’s Report Connections or PivotTable Connections. Layout settings cannot repair an incompatible connection or a report based on unrelated data.

Horizontal slicers compared with other filter controls

A horizontal slicer is best when users need visible, one-click access to a relatively small set of categories. Unlike a standard filter drop-down, it keeps choices visible on the worksheet, making the current selection easier to notice. The trade-off is worksheet space: a slicer occupies room even when its choices are not being changed.

A filter drop-down is often more compact for a field with many values, though users must open it to see and select options. A Timeline is purpose-built for filtering date fields in supported PivotTable scenarios and offers a time-oriented control rather than a grid of ordinary labels. For a very long list, the filter menu or a carefully designed report control may be more practical than a horizontal slicer.

These controls are not interchangeable in every workbook. Choose based on how many choices exist, how often readers will change them, and whether visibility or compactness matters more. A small set of product types may work well as horizontal buttons; hundreds of individual products usually do not.

Frequently Asked Questions

Can I make an Excel slicer horizontal?
Yes. Select the slicer, open the Slicer tab, and increase Columns in the Buttons group. Resize the slicer so the buttons have room.

Is there a horizontal orientation button for slicers?
Usually, no separate orientation toggle is needed. The Columns setting arranges slicer buttons in a grid, producing a horizontal layout when the value is greater than 1.

How do I put all slicer buttons on one row?
Set Columns to the number of items you want across, then make the slicer wide enough for the labels. If the field has many items, one row may be impractical or too crowded.

Why are my slicer buttons still stacked vertically?
Check that Columns is set above 1 and that you selected the slicer object before looking for the setting. Widen the slicer if the buttons do not have enough room to form a clear grid.

Can one slicer control several PivotTables?
Sometimes. Use Report Connections or PivotTable Connections to select compatible PivotTables. They generally need to share a suitable data source or cache; the slicer’s horizontal layout does not affect its connections.

Does changing slicer columns change the filter results?
No. Columns changes the button arrangement only. The selected slicer items and its report connections determine which data is filtered.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.