Yes. To filter an Excel PivotTable by month, group its date field by Months and Years, then add a slicer for the grouped month field; for a date-range control, insert a Timeline instead. For an ordinary Excel table, add a month helper column first, because a table slicer filters the values in a column rather than grouping dates into months automatically.
What a month slicer does
A slicer is a set of clickable buttons that filters a table or PivotTable. It can make a monthly report easier to explore than a conventional filter menu, especially when a reader needs to change the reporting period without opening field dropdowns. A slicer also shows which values are selected, so the current filter is more visible.
Excel does not generally turn a date column into month buttons just because you insert a slicer. A date might contain hundreds of individual days, and Excel needs a month-level field or a date timeline to filter by month. The right method depends on whether your report is built from a PivotTable or a regular table, and whether you want month names, month-and-year choices, or a continuous date range.
One important distinction: a slicer for Month alone can treat every January as the same month, regardless of year. If a dataset covers several years, make sure the report also distinguishes years, or use a Month-Year field or Timeline. Otherwise, selecting January may combine January 2024, January 2025, and other Januaries.
Add a month slicer to a PivotTable
For most monthly summaries, a PivotTable is the most direct approach. The source date column must contain real Excel dates, not date-looking text. In a PivotTable, date grouping creates month and year fields that can be used as slicers.
- Click a date cell in the PivotTable and confirm that the field contains usable dates. If necessary, correct the dates in the source data and refresh the PivotTable.
- Right-click one of the displayed dates and choose Group. Select Months. If the data spans multiple calendar years, select Years as well, then choose OK.
- Click inside the PivotTable. On the Windows ribbon, choose PivotTable Analyze > Insert Slicer.
- Select the grouped Months field in the list and choose OK. If useful, repeat the insertion for the Years field.
- Move and resize the slicer, then click a month button to filter the PivotTable. Use the clear-filter button on the slicer to remove its selection.
Grouping typically makes separate Months and Years fields available in the PivotTable field list. Put Years in a slicer or report filter and Months in a slicer to make the year explicit. For example, selecting 2025 in the Years slicer and February in the Months slicer narrows the report to February 2025. If you select February without restricting the year, the PivotTable may include February from every year in the source.
Grouping is also useful when the PivotTable displays dates in rows or columns: it changes the reporting level without altering the original dates in the source table. The grouping applies to the PivotTable, not by rewriting each source date. You can still use the original date field for a day-level analysis elsewhere.
Use a Timeline for date ranges
A Timeline is Excel’s date-oriented filter control for a PivotTable. It is often a better choice when users need to move through periods or select a span of dates, rather than click a short list of month names. Click the PivotTable, choose PivotTable Analyze > Insert Timeline, select the date field, and choose OK. The Timeline provides a time-level selector; choose Months when you want to work at month granularity, then select the month or span to display.
A Timeline is not identical to a month slicer. A grouped-field slicer presents buttons for values such as Jan, Feb, and Mar, which can be convenient for choosing particular month categories. A Timeline represents a date axis and is designed for selecting periods or date ranges. If a report must show one specific month in a particular year, verify the selected year and range rather than assuming that a month label alone identifies a unique month.
Timelines apply to PivotTables, not directly to an ordinary Excel table. A Timeline can also control more than one PivotTable when they share a compatible PivotTable data source or cache and are connected. Use the Timeline tab’s Report Connections command, where available, to choose the PivotTables it should filter.
Filter an ordinary Excel table by month
A regular Excel table does not have PivotTable-style date grouping. Its slicer filters the exact values in the selected table column. If you add a slicer for a Date column, the choices are dates rather than a built-in hierarchy of month and year. Add a helper column that assigns each row to the first day of its month, then format that column to display a month and year.
For example, assume your Excel table is named Sales, contains a Date column, and you add a MonthStart column. In each row of MonthStart, enter:
=DATE(YEAR([@Date]),MONTH([@Date]),1)
For a source row dated February 15, 2025, the formula returns the date February 1, 2025. Format the MonthStart cells with a date format such as mmm yyyy so the displayed value reads Feb 2025. The underlying value remains a genuine date, which is usually more useful for chronological sorting and later calculations than a text label.
To add the filter, click inside the table and choose Table Design > Insert Slicer, then select MonthStart. Click the resulting month-year buttons to filter the table rows. Table Design is a contextual tab, so it appears when the table is selected. If you do not see it, check that the data is an Excel table rather than a plain range; use Insert > Table to convert a range when appropriate.
A table slicer filters that table, but it does not automatically filter unrelated PivotTables or charts. For a dashboard containing summaries, build the report around PivotTables and connect the slicer to those PivotTables, or ensure the relevant visuals use the filtered table as their data source. Keep the helper column in the source table so new rows can inherit its calculated formula.
Choose the right month-filter method
Use the control that matches the question your report needs to answer:
- Grouped Month slicer: Good for choosing month categories such as March or October in a PivotTable. Add a Year slicer too if the data spans multiple years.
- Month and Year fields: Best when users need to identify one calendar month, such as October 2026, without combining it with the same month in other years.
- Timeline: Useful for moving across a date range or selecting a continuous period from a PivotTable.
- MonthStart helper column: Practical for filtering a normal Excel table with a slicer, or for building a month-year field in the source data.
- Built-in date filter: Enough for occasional filtering when a visual slicer is not necessary. Use the column dropdown to filter the date field, or filter the PivotTable field directly.
For example, a sales summary that compares total sales by month across several years may need both Year and Month controls. A report asking for sales between April 10 and June 20 is better suited to a Timeline or a date filter, because the requested interval begins and ends partway through months. A simple slicer with month names cannot express that exact range on its own.
Common problems and how to fix them
- Group is unavailable or grouping fails: Check the source date column for text values, blanks, errors, or inconsistent entries. Correct the source, refresh the PivotTable, and try grouping again. A cell that looks like a date may still be stored as text.
- The month slicer combines years: This is expected when the slicer uses only a Months field. Add a Years slicer or use a month-year field so each calendar month is distinct.
- New records do not appear: Confirm that the PivotTable source includes the new rows. Using an Excel table as the source generally makes expansion easier; then choose PivotTable Analyze > Refresh after adding data.
- The slicer does not affect another PivotTable: Select the slicer and use Report Connections, sometimes labeled PivotTable Connections, to check its connections. The PivotTables generally need a compatible shared source or cache for one slicer to control them.
- Month buttons appear in an unexpected order: Use actual date values for a MonthStart helper field rather than text labels such as Apr 2025. Date-based values preserve chronological meaning more reliably; check the column’s sort and display format.
- There is no Table Design tab: Click inside the data and confirm it is formatted as an Excel table. A slicer cannot be inserted for an arbitrary plain range in the same way as a table or PivotTable.
After changing the source data, refresh the PivotTable so its grouped fields and slicer items reflect the current records. If grouping still fails after fixing the source, recreate the PivotTable from the corrected data; this can help when an old PivotTable cache retains problematic source values.
Practical layout and compatibility notes
Keep slicers close to the report they control and give them descriptive headings, especially when a dashboard has separate Year, Month, Region, or Product filters. Slicer selections persist in the workbook, so save the file in a state that makes the intended starting view clear. A reader can usually use the clear-filter control to return to an unfiltered view.
These steps describe Excel for Microsoft 365 on Windows. On Excel for Mac, contextual ribbon tabs and commands can be arranged differently, and availability can depend on the installed build; look for PivotTable Analyze and the Insert Slicer or Insert Timeline commands when working with a PivotTable. Excel for the web can display and use many existing slicers, but desktop Excel is the more dependable place to create or adjust PivotTable grouping and dashboard controls. If a command is missing in a particular build, a MonthStart helper column is a useful fallback.
Frequently Asked Questions
Can an Excel slicer show months instead of individual dates?
Yes. In a PivotTable, group the date field by Months and insert a slicer for the grouped Months field. For a regular table, create a month helper column and insert a slicer for that column.
Why does selecting January show several years?
A Months field identifies the month name, not a unique month-year. Add a Years slicer and select the year you want, or filter a field that contains distinct month-year values.
Can I use a slicer on a normal Excel table?
Yes. Click the table and choose Table Design > Insert Slicer. The slicer filters the values in a table column, so use a helper column if you want month-level choices instead of individual dates.
What is the difference between a slicer and a Timeline?
A slicer filters field values using buttons. A Timeline is a date-focused PivotTable control for navigating dates and selecting periods or ranges. Use month grouping for month-name choices and a Timeline for a date-axis selection.
Can one month slicer control multiple PivotTables?
Often, yes, if the PivotTables share a compatible data source or cache. Select the slicer and check Report Connections or PivotTable Connections; a PivotTable that does not share the required source may not be available to connect.
Related
- Excel Power Query Wildcards: What Works and What Doesn’t
- Excel Power Query Value Transformation: Types and Steps
- Excel Power Query Training: Skills, Courses, and Practice
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add Chapter Page Numbers in Word: A Step-by-Step GuideTo add chapter page numbers in Word, format your chapter titles with the numbered Heading 1 style, then…
- Excel Conditional Formatting for Upcoming DatesYes. In Excel for Microsoft 365 on Windows, select the date cells, choose Home > Conditional Formatting >…
- Inserting Citations in Word: A Step-by-Step GuideTo insert a citation in Microsoft Word for Microsoft 365 on Windows, place the cursor where the citation…
- Can You Insert a Page Break in Excel? Yes, Here’s HowYes. In Excel for Microsoft 365 on Windows, select the row below or the column to the right…
- Excel Solver for Resource Allocation: A Practical GuideYes. Excel Solver can allocate limited resources by choosing values for decision cells that maximize an objective, such…
- Excel Power Query JSON: Import, Expand, and RefreshIn Excel for Microsoft 365 on Windows, import a JSON file with Data > Get Data > From…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.